SQL 2000 - LIKE Statement

[dhutton]

Hello

I'm trying to filter out service orders numbers that begin with a letter - I just need numbers. For example my query would return:

11490
A6578
66451
12345

I want to filter out the service order with the letter A. I have tried this:

WHERE ServiceNumber LIKE <> (A%) but it doesnt work. Does anyone have a suggestionas to how to do this?

Thanks

dhutton

[iburyak]

Try this:

WHERE ServiceNumber NOT LIKE 'A%'

or

WHERE ServiceNumber LIKE '[0-9]%'

Good Luck.