Query for wild cards in string

[llmclaughlin]

I'm going to have a string passed to a query. The string will be something like GT024A8183838. The string will not always be the same length which is where my problem comes in. The table that get's queried will the have the string as GT024A?1?????

When i run the query with GT024A8183838 it needs to find the one like GT024A?1?????

Thanks in advance

 

[kskid]

I believe what you want is

field like 'GT024A_1%'

 

[kskid]

I forgot to add that the _ (underscore) is a place holder while the % (percent) can contain any number of characters.

 

[cmmrfrds]

Oracle 10G supports Regular Expressions which can be used to find data that have certain patterns.

See this link for examples.

http://www.psoug.org/reference/regexp.html