Question Re: Like Operator in Technology Q&A

Like Operator

Former Member — Sun, 01 Sep 2013 09:06:48 GMT

Hi All,

I need to check the below condition to suppress a section.

My query is like this

SELECT scan_mode,STATUS,transaction_no FROM gfi_transaction WHERE transaction_id={?TID}

If transaction no starts with GR then i need to hide a particular section.The value for transaction no is GR_9

I wrote condition like this

transaction_no like "G?" but not working .

Please suggest.

Re: Like Operator

abhilash_kumar — Mon, 02 Sep 2013 05:27:33 GMT

Hi Divya,

The formula should be:

transaction_no LIKE "GR*"

-Abhilash

Re: Like Operator

Former Member — Mon, 02 Sep 2013 05:40:34 GMT

Hi Abhilash,

Can you please tell why "G?" is not working ?

Re: Like Operator

abhilash_kumar — Mon, 02 Sep 2013 05:53:32 GMT

That's because '?' stands for a single character whereas '*' stands for any number of characters.

So, 'G?' will be True only when the value is 'GO' or 'GT' etc.

'G*' will be True for longer words that start with G.

-Abhilash

Re: Like Operator

Former Member — Mon, 02 Sep 2013 06:06:35 GMT

Hi ,

TRY with 'GR%'.

Regards,

Priyaranjan

Re: Like Operator

Former Member — Mon, 02 Sep 2013 06:17:25 GMT

If transaction no starts with GR then i need to hide a particular section.The value for transaction no is GR_9 
I wrote condition like this  
transaction_no like "G?" but not working .

Transaction_no like 'GR%' should work in this scenario.

and also rememnber that value given is case sensitive.

Regards,

Priyaranjan

Re: Like Operator

abhilash_kumar — Mon, 02 Sep 2013 06:50:36 GMT

Thanks Priyaranjan, however '%' is Not a recognized wildcard symbol (with the LIKE operator) in Crystal Reports.

You have to use either '?' or '*' with the Like operator in Crystal Reports.

-Abhilash