Hi,

I am developing a launch page where there are text boxes for firstname,lastname.The requirement is when the user enters firstname in lowercase letters it should be converted into CAPS,because firstname is stored in CAPS in the database.To achieve this I am using UPCASE() function.

Now there is new requirement,where firstname can be in uppercase or lowercase or mixedcase in the database.
for example if the user enters 'temp' in the textbox and we have 'Temp','TEMP','temp' in the database.user should be able to see all the three records.

Can somebody put some thoughts into this.Thanks.

This message has been edited. Last edited by: Kerry,

Try using the UPCASE function on both the input field and the database field. I did that and it works.

Which database?

If you're using SQL Server then the COLLATION settings may help.

See some ideas here.

Thankyou both RSquared and njsden.
I tried both the ways and they worked fine for me.
The COLLATION setting is very helpful.