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]%')
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):
. Check for publisher's certificate revocation
. Check for server ce…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…