WILDCARDS 1

[ajdesigns]

Where could I find information /help on sql*plus including wildcards
I am new to oracle reports and I know that the data is returned from an SQL*Plus query. For instance I need to return a field where to data in the fiels starts with * normally I would use something like in the where clause WHERE text_value =*% but this does not work.
I would appreciate Any help
AJD

 

[nagornyi]

In your case it will be

WHERE text_value like '*%'

Percentage % replaces any number of characters, while underscore _ may replace a single character.

 

[cruishall]

have you tried doing this?

select *
from table_name
where field_name like '%whateverstring%';

???