Request for help in regard to the select statement where clause Ex:(Select single name into v_name from XYZ where text = string).
String and text data types are same.
String will have only 3 char and text will have 40 char of length.
Out of 40 char I would like the where clause to search any of the 3 char and fetch the record.
Hope my question is clear and can expect help on this regards,
Thanks,
Azhar.