Like Operator

[Former Member]

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.

[Former Member]

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

[abhilash_kumar]

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