regarding comparison in sql

[trysenthil]

thanks,
one more doubt:

while retrieving the data that is stored in oracle dbase., and comparing that particular field eg.name we are writing as name='INDIA' .
how the comparison works with the name if i have 'iNDIA' OR 'INdia'

[r035198x]

thanks,
one more doubt:

while retrieving the data that is stored in oracle dbase., and comparing that particular field eg.name we are writing as name='INDIA' .
how the comparison works with the name if i have 'iNDIA' OR 'INdia'

You can use the UPPER function
[CODE=sql]... where UPPER(name) = UPPER('iNdIa')[/CODE]

[trysenthil]

You can use the UPPER function
[CODE=sql]... where UPPER(name) = UPPER('iNdIa')[/CODE]

thanks for your clarification