Hi just a quick question, how do you query tables in DB2. Ive been uysing mysql so know most of the commands, but if i want to search a table for things like "select * from person where birthdate>'1982'" it doesnt let me. Can i use sql commands? for example like, >, <, %text%, and if so how? Thanks!

You may want to look at the SQL reference:

http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

There are some differences between SQL dialects; in your case it is the way db2 handles date-time literals, I assume.

You may also want to have a look at the SQL cookbook ...

Link available in www.db2click.com

Cheers
Sathyaram