New to DB2

[sabavno]

Hi

I am new to DB2 and need your help

Please help with the SQL statement to select all records that have PROD in the body of the Description field

In Access I would write this:

SELECT * FROM TABLE1 WHERE DESCRIPTION LIKE '*PROD*'

But that does not seem to work in DB2

Please help

 

[PruSQLer]

You just need a different wildcard character, the % (per cent sign)

Select *
From Table1
where description like '%PROD%'

This stuff would be too easy if all DBMS's used the same symbols.