case in-sensitive sql query

[raghuvanshi]

In the interview test one of the questions was asked in which I have doubt is below-:

If a table has a VARCHAR columns, containing values: prod,system,PROD,Test,Prod. Which one of the following queries will find all the records containing 'PROD' irrespective of the case?

a) SELECT * FROM TABLE WHERE COLUMN=IGNORE_CASE('PROD')
b) SELECT * FROM TABLE WHERE COLUMN=LOWER_CASE('prod')
c) SELECT * FROM TABLE WHERE LCASE(COLUMN)='prod'
d.) None of these
My answer was a)

[raghuvanshi]

Hi,

Any suggestions are welcome.

[BillyBoyo]

With the benefit of the time that has elapsed, what have you discovered by looking in the manuals?

[raghuvanshi]

C is the correct answer

[BillyBoyo]

That's nice and definitive. Can you provide a link to the manual reference that you found, it can help other people looking at the same type of thing in the future?

[raghuvanshi]

Hi,

Please find the link below

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNSQK10/3.2.61?DT=20070125023435