View Single Post
Old 22nd July 2008, 11:48   #20
DimPrawn
Godlike
 
DimPrawn's Avatar
 
Join Date: Jul 2005
Posts: 10,101
Default

Quote:
Originally Posted by EvilWeevil View Post
Have you considered...

SELECT band_name
FROM bands
WHERE band_name like (replace(@p,'#','[0-9]')+'%')
No. A good concise answer.
__________________
By the time you finish reading this sentence, the national debt will have risen by another £1,500 - which you or your children will have to repay.

Just so you know.
DimPrawn is offline   Reply With Quote