[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::odbc_rdb_driver

Title:DEC ODBC Driver
Notice:DEC ODBC Driver V2.0 Now Available
Moderator:SQLSRV::MAVRIS
Created:Tue Dec 29 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1357
Total number of notes:4864

1287.0. "Case Insensitivity against RMS ?" by ORAREP::FUTURS::MARSHALL1 () Mon Jan 20 1997 09:33

T.RTitleUserPersonal
Name		DateLines
1287.1A better conference for this question ??ORAREP::FUTURS::MARSHALL1Thu Feb 20 1997 13:3518
    
    	Anyone have any answers to this, or a pointer to a conference where
    	this question would be better asked ??
    
    	As predicted, the users now want to do a case-insensitive query
    	against their RMS files, and I don't believe it can be done.
    
    		SELECT * FROM tblMyTable WHERE strField LIKE 'aaa*'
    
    	to match all of:
    
    		strField = 'aaab'
    			 = 'Aaab'
    			 = 'aAab'	and so on.
    
    
    	Steve
1287.2ignore case?BROKE::ABUGOVThu Feb 20 1997 18:3313
    
    Hi Steve,
    
    There probably is a better conference, but I don't know which one it
    would be.  I think if you add 
    
    IGNORE CASE
    
    to the end of the statement it should work.
    
    Hope this helps,
    
    Dan
1287.3Upgrade Rdb and Patch - FixedORAREP::FUTURS::MARSHALL1Fri Feb 21 1997 09:4418
    
    Hi folks,
    
    	the machine I was testing against was well out of date with the
    	version of Rdb. It has now been upgraded and had a number of
    	patches installed, which seems to have fixed the problem.
    
    	Using:  
    
    		UCASE(<fieldname>) LIKE '<string>*'
    
                	now works fine ....
    
    	Cheers,
    
    		Steve.