KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
What is the complete list of all special characters for a SQL (I'm interested in SQL Server , but other's would be good too) LIKE clause? E.g., SELECT Name FROM Person WHERE Name LIKE '%Jon%' SQL Server : % _ [specifier] E.g. [a-z] [^specifier] ESCAPE clause E.g. %30!%%' ESCAPE '!' will evaluate 30% as true ' characters need to be escaped with ' E.g. they're becomes they''re MySQL: % - Any string of zero or more characters. _ - Any single character ESCAPE clause E.g. %30!%%' ESCAPE '!' will evaluate 30% as true Oracle: % - Any string of zero or more characters. _ - Any single character ESCAPE clause E.g. %30!%%' ESCAPE '!' will evaluate 30% as true Sybase % _ [specifier] E.g. [a-z] [^specifier] Progress: % - Any string of zero or more characters. _ - Any single character Reference Guide here [PDF] <a href="http://www.postgresql.org/docs/7.4/interactive/functions-matching.html" rel="nofollow noref
Tags (comma-separated)
Save Edits
Cancel