how to use % symbol in Like statement.
Database
2
Posts
2
Posters
0
Views
1
Watching
-
HI, i want to filter no.of rows where field1 contains symbol like %. How to select only those records contains like 20%,30%...etc. ************ S G KORE *******************
-
HI, i want to filter no.of rows where field1 contains symbol like %. How to select only those records contains like 20%,30%...etc. ************ S G KORE *******************
SELECT * FROM [Table] WHERE [Field] LIKE '%[%]'
thatraja |Chennai|India|
Tips/Tricks|Brainbench certifications
Do what you want quickly because the Doomsday on 2012 :-)