I have this regex and i swear it was working but now it doesnt. I have order numbers like
WS0000095-1 OR WS0000095 (no dash). I will also have other order numbers like
3199888111 or 99900011-1 (just numbers or numbers with dash)
How can I check if an order number starts with alpha?
declare @orderNum varchar(15)
set @ordernum = 'WS0000095-1'
if (@orderNum LIKE '[A-Za-z][A-Za-z][A-Za-z]%')