Problem with LIKE clause
Posted: Fri Dec 17, 2010 1:21 pm
Hi All,
I am facing some problem with LIKE clause in DB2 query
I have rows as below for column name PROGRAM_NAME
PROGRAM_NAME
*******************
AA12BB
AA11BB
AA13BB
AA11CC
AA12CC
ABCDEF
I need to the result which are starting with AA and ending with BB as below
PROGRAM_NAME
*******************
AA12BB
AA11BB
AA13BB
I have used the below query
SELECT * FROM TERROR_LOG
WHERE PROGRAM_NAME LIKE 'AA__BB';;
But im getting zero rows.
Could you please help in this regard.
I am facing some problem with LIKE clause in DB2 query
I have rows as below for column name PROGRAM_NAME
PROGRAM_NAME
*******************
AA12BB
AA11BB
AA13BB
AA11CC
AA12CC
ABCDEF
I need to the result which are starting with AA and ending with BB as below
PROGRAM_NAME
*******************
AA12BB
AA11BB
AA13BB
I have used the below query
SELECT * FROM TERROR_LOG
WHERE PROGRAM_NAME LIKE 'AA__BB';;
But im getting zero rows.
Could you please help in this regard.