CREATE TABLE SEARCH_WILDCARD (ID INT,NAMES VARCHAR(25))
INSERT INTO SEARCH_WILDCARD VALUES
(1,'WILDCARD%WILDCARD'),
(2,'NO_WILDCARD'),
(3,'%'),
(4,'WILDCARD%'),
(5,'%WILDCARD')
SELECT * FROM
SEARCH_WILDCARD
Output:
ID NAMES
-----------
-------------------------
1 WILDCARD%WILDCARD
2 NO_WILDCARD
3 %
4 WILDCARD%
5 %WILDCARD
--Now if you want get records having '%'
--All values
with % in any position
SELECT * FROM
SEARCH_WILDCARD WHERE NAMES LIKE '%[%]%'
--All values
only with %
SELECT * FROM
SEARCH_WILDCARD WHERE NAMES LIKE '[%]'
--All values
ending with %
SELECT * FROM
SEARCH_WILDCARD WHERE NAMES LIKE '%[%]'
--All values
starting with %
SELECT * FROM
SEARCH_WILDCARD WHERE NAMES LIKE '[%]%'