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]

Hi ,

TRY with 'GR%'.

Regards,

Priyaranjan