Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-13 : 22:03:14
|
osi writes "Is there an equivalent of "UPPER" function to perform on text datatype?
What I am doing is
SELECT description
FROM MyTable
WHERE UPPER(description) like UPPER(MySearchText).
I am searching "MySearchText" in "description" column using "UPPER" function to avoid the case sensitivity.
This works if "description" is char datatype. It gives an error if it is text datatype. How can I perform a search (no case sensitivity) on a column which is a text datatype.
Many thanks" |
|
|
|
|
|
Pattern search without case sensitivity on text datatype