Posted on 2013-01-09
I have a need to query some data from our Item master table. However, the item_id consists of mixed numer, alpha, and alphanumeric.
I only wants to pull the alphanumeric numbers. The first 3 or more length of the item_id needs to be alpha follow some numbers.
122929099Klkls <--don't pull
TTED992929 <--This is the one I want
2939392090 <--don't pull
With the above how can I construct my query to pull only alphanumeric item_id and the first 3 characters are more needs to be alpha?
SELECT ITEM_ID, DESCRIPTION FROM INVENTORY
WHERE SUBSTRING(ITEM_ID, 1, 3) LIKE ('[A-Za-z]%')
Can't get the above to look at least the first 3 characters to make sure it's Alpha. It's pulling A12322323 into my report. I need to have at least 3 letters or more followed by numbers.