Monday, August 16, 2010

"upper" in case of schema.ini / oledb / excel sheet query

In case of querying with the Schema.ini / oledb / excel sheet query  and u need to apply a check based on upper case then you need to declare like this.

 

UCASE(RTRIM(LTRIM((C.NAME)))) = UCASE(RTRIM(LTRIM((A.NAME))))

 

For lower case use this-  LCASE.

 

 

 

 

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Code Formater

Paste Here Your Source Code
Source Code Formatting Options
1) Convert Tab into Space :
2) Need Line Code Numbering :
3) Remove blank lines :
4) Embeded styles / Stylesheet :
5) Code Block Width :
6) Code Block Height :
7) Alternative Background :
Copy Formatted Source Code
 
Preview Of Formatted Code