How To Remove numbers if Starting with Character

[pra_kale]

Hi,

How to remove numbers starting with character while uploading the data.

for e.g. in my data i am having numbers like 123457, 135678, AB12345, CD4566 then while uploading the data i not want numbers starting with character. currently I am doing this by trim(left(Numbers,1))<>'C'  and trim(left(Numbers,1))<>'A'. 

Can i am upload with a single condition only where numbers starting with characters are not get's uploaded.

Thanks in advance.

[sunny_talwar · Accepted solution]

May be this:

Where IsNum(Left(Trim(Numbers), 1));

[pra_kale]

Thanks Sunny. It is working fine.