How to select records starting from number?

[erxefera]

Hi!
Can anyone help me how to create query selecting only the records starting with the numbers?

Thanks a lot in Advance

 

[gromit]

hi -

not exactly sure what you mean by a "record starting with a number"

If you have a text field that can contain both letters and digits (0-9) then you can use a string function to test if the first character is >0 and <9.

hth,

g