LIKE OPERATOR % WILDCARD

[kenyoj]

Hi

I am altering a SQL command in Crystal XIr2. I have added the following line of code to search for QUEUECD that startswith IOM:

OR (("BI0002"."QUEUECD" like 'IOM%' and "BI0002"."SUSPFLAG"='Y')
AND ("BI0002"."EVENTCODE"='BIUPDATEW' OR "BI0002"."EVENTCODE"='BISUSPND'))

Unfortunately the function startswith cannot be used within the command editor. I have also tried like 'IOM*'. It errors with invalid arguement. Any suggestions would be gratefully received!!

 

[IanWaterman]

Use

If Oracle

Substr("BI0002"."QUEUECD", 1,3) = 'IOM'

MSSQL

Substring("BI0002"."QUEUECD", 1,3) = 'IOM'

Ian

 

[ShortyA]

Ah another AWD BI implementer and I am guessing from the queue code that it is in financial services. How are you finding the BI product ? Have you done much customisations ? I implemented it for a client a few years ago and am interested that is all!

Regards - Alec
alec dot short at thackeray dot co dot uk

 

[Thant]

Im using CR 2008. Sorry forgot to post that before

 

[lbass]

If you are using "add command" then your code should work using: like 'IOM%'. Can you confirm that you are working in the command area and not trying to implement this in a SQL expression?

Also, what error message did you get using the "like 'IOM%'"?

-LB