Assuming that the name of the table is "test1" and the variable containing
the values of interest is name "values", then:
SELECT * FROM test1 WHERE values LIKE 'JYR%';
On Tue, 19 Sep 2000, John Draper wrote:
> Ok, I have a question... lets say I have a key fields like this...
>
> JYR-34a
> JYR-34b
> JYR-34c
> JJG-67
> jUY-89
>
> I want to do a query on a substring, such that I can get all three
> of the JYR's to come up, regardless if it has an "a", "b", or "c"
> after it. Is that possible in SQL? If so, what would the query
> look like?
>
> John
>
>