Return only numeric values

[patnick]

Could you please help me on this!

I have a table T, with values which are mixed of numeric and alphabetic signs.

e.g.:
5 - England
Greece
2 - USA
Germany

I want my query to return only the two values 5 and 2 but nothing else. Could you please tell me how an sql should look like?

Many thanks for your help in advance!
Cheers,
Patnick

 

[Brianwarnock]

See if the VAL function will work for you.

Brian

 

[patnick]

Thank You Brian!