Hello,

I am new to this forums and new to DB2 too.

I need some help regarding the LIKE operator in DB2.

Here is my requirement.
I have a table that has values like:
1234
12345
12345AB
1234AB
AB1234CD
1234ABCD

I am supposed to write a query that looks for '1234' and return these values:
1234
1234AB
AB1234CD
1234ABCD

Any help is greatly appreciated.

Thanks,
Nikhil

Why do these two rows not qualify?

Andy

Andy,

I am looking for row values that has the number '1234' in it along with alphabets but not numbers, at the beginning or at the end.

Nikhil.

Something along these lines:

Nick, out of curiosity have you ever evaluated what it does to performance using translate? I have never had to use it.

Why aren't you able to do:

select <column_name> from <table_name> where <column_name> like '&#37;1234%';

Maybe I'm missing something.

Nikhil's replay to Andy's question:

The 4 numbers have to be can NOT have another number immediately before or after it. It has to be nothing or an alpha character.

Using %1234% would return 12345 and 12345AB and both of these violate the restriction.

What's with rows like 0ABC1234def567? If such a row should qualify, the TRANSLATE approach won't work either.