"CONVERT" SQL string to number

[#1]

<p>Ok, total newbie,</p><p>I have a field in a sql server database that is a string.</p><p>I wish to read it and convert it to a number, it seemed "CONVERT" in the formula workshop was maybe the way to go?</p><p> I tried this and every other version of integer, num etc I could think of.</p><p>{fn CONVERT("RecipeIngredients"."Scale", smallint )}</p><p>I always get the there is an error in this expression message.</p><p>how is this done?</p><p>thanks in advance</p><p>mark</p>

[Former Member · Accepted solution]

Hi,

In crystal report if you want to change text to number their is a built-in function. ToNumber(Field_xxx as String) or if other way around. ToText(Field_xxx as Number).

Regards,

Clint