Tuesday, January 31, 2012

primitive expression in sql server like

for example the following will retrieve any string beging with e and having 4 trailing numbers

select ucode , ulastname, semail from person
where ucode like 'e[0-9][0-9][0-9][0-9]'

No comments:

Post a Comment