SEARCH in TEXT field type in CASE SENSITIVE MS SQL SERVER 2000 Database
Posted on 2004-08-17
I am having a problem with a simple select query which can be displayed as follows:
SELECT ID, NAME
WHERE TABLE1.TEXTFIELD1 LIKE '%MySearchText%'
Since the Database is case sensitive I will have to use the UPPER function in the statement but the TEXT field type in the Database doesn't support this function.
Making database case insesitive in run time is not advisable since the database is shared in the network.
Is there anyone around who can help me?