Need to convert text to numbers

[crumpm]

Progress database with Crystal Reports 2008


I have a table where the key indexes are stored as text instead of numbers (which they are in every other table in the DB)

I need an SQL expression to speed up the conversion as the report often fails when there are a large number of transactions.

e.g transaction.client_number (text)

which I need to link to file.client_number (number)

I'm trying to use {fn CONVERT("transaction"."clinet_number"), xxxx}

but I don't know what to put for xxx and can't find a list anywhere.

Thanks

 

[lbass]

Try:

{fn CONVERT("transaction"."client_number",sql_varchar)}

-LB

 

[IanWaterman]

I have not used Progress but I read somehere that syntax was similar to Oracle, in which case it would be

to_number(transaction.Client_number)

Ian

 

[lbass]

Sorry, I thought you were converting in the other direction. Try:

{fn CONVERT("transaction"."client_number",sql_integer)}

I don't have access to Oracle right now so couldn't test this though.

-LB

 

[crumpm]

Thanks, I will try the integer as I think is what I'm looking for.

 

[crumpm]

Great, that did the trick. Thanks