Forum: MS SQL May 9th, 2008 |
| Replies: 1 Views: 1,403 get rid of the square brackets around the varchar(255) and it will work fine.
For that matter, why are you putting them around the datatypes anyway? I've never seen anyone do that. |
Forum: MS SQL May 9th, 2008 |
| Replies: 3 Views: 3,911 select * from persons where (prefix like '%'+@input+'%'
or
firstname like '%'+@input+'%'
or
lastname like '%'+@input+'%')
and address like '%'+@addressinput+'%' |
Forum: MS SQL Nov 1st, 2005 |
| Replies: 10 Views: 11,378 or simply "select 50. / 100" |