Link to home
Start Free TrialLog in
Avatar of gvamsimba
gvamsimbaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

TSQL Wild Characters Query

HI, below is my query..can anyone clearly explain to me
what the following wild characters are doing ?
1) select addressee from mytable where charindex(' ', reverse(addressee)) - 1 > 0
	and len(right(addressee, (charindex(' ', reverse(addressee)) - 1))) < 2
 
2) select postcode from mytable where postcode like '[a-zA-Z][a-zA-Z] %'
 
3) select address1 from mytable where address1 like replicate('[0-9]',len(rtrim(ltrim(address1))))

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gvamsimba

ASKER

thank you..