cast problems

[Damanindahaus]

hi mates,
i need ur help. i dont know where the syntax problem comes from in this code:

select INTEGER(SUBSTRING(STRING(table.column, "9999999999":U), 10, 1)) columnname from table

can u help me plz?

regards
Daman

 

[MaximMonin]

string doesnt understand format "9999999999". It is integer/decimal format
You have to use something like
SUBSTRING(STRING(decimal (table.column,"9999999999")),10,1)

 

[Damanindahaus]

thx. unfortunately it doesnt run with my version. i export this to .net and handle this outside of progress.