request a max string value as a integer rules

[rasimsen]

hi,

data type is string. So when we use sql command

data sample:5,8,10,20,9,3,89

select max(kimlik) from table

result:9

we want to find "89"

how can we do with interbase.

also we used this "cast()" function like this:

select max(cast(kimlik as integer)) from table

result: error


please urgenly help.

we apprecite anyhelp!

thank

best regards.

 

[MartijnTonies]

>result: error


WHAT error?

Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com