CONVERT

[mgason]

I am a Crystal newbie,
In Formula workshop Crystal XI can I convert a string coming from a SQL database to a number?
For reasons beyond my control the field must be a string in the SQL database but only contains numbers.
I tried this, and every other sort of term for number I could think of, like Int, Num etc

{fn CONVERT("RecipeIngredients"."Scale",<smallint> )}

no luck.
can CONVERT do this?
If not Is there another way?

thanks
mark

 

[dgillz]

Write a formula in crystal:

Tonumber({YourField})

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mgason]

I tried this
Tonumber({"RecipeIngredients"."Scale"})
I get there is an error in this SQL expression?

 

[lbass]

dgillz was suggesting that you could use a Crystal formula, not a SQL expression, to do the conversion. It is true, though, that a SQL expression would be speedier. Try this SQL expression:

{fn convert("RecipeIngredients"."Scale",sql_smallint)}

-LB

 

[mgason]

Thanks,
newbie I am!
I completely failed to understand dgillz meant formula. (or really to realise I was not writing one in the "formula workshop" yes I am that new!)