Contractor UK Bulletin Board - View Single Post - SQL to restrict rows by first letter / number

EvilWeevil · 11th July 2008, 08:05

Have you considered...

SELECT band_name
FROM bands
WHERE band_name like (replace(@p,'#','[0-9]')+'%')

11th July 2008, 08:05	#18
EvilWeevil Lurker not a fighter Join Date: Mar 2008 Posts: 74	Have you considered... SELECT band_name FROM bands WHERE band_name like (replace(@p,'#','[0-9]')+'%')