How to use uCase in command objects

[crystal28]

In a SQL Statement in command object how do i use the Ucase function in the where clause,i know this might seem primitive but i really need to know

 

[dgillz]

This could vary by the database you are using. What is the database? MS SQL Server? If so the function is simply Upper()

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[crystal28]

Database is Oracle and i am trying to create a command object in Crystal with a where condition containing a ucase...

 

[lbass]

If it won't accept ucase(), try:

{fn ucase("table"."field")}

-LB

 

[crystal28]

Upper did work.thanks...is there a link where i can view help on SQL in command objects in crystal,i tried to search BO website,not very detailed,even in Crystal reports manual there isnt much info on Command objects

How to create a Procedure to return 100s of rows which can be used in a command object to create a report?