Re: Upper and Lower Case

>>I don't won't to differentiate in online upper and lower case. How to do it? >> >>f.e. >>data >>------ >>mar >>Mar >>MAr >>MAR >>maR >> >>querry: >>select data from table where data = "mar";>>result: >> >>data >>------ >>mar >> >>I need result: >> >>data >>------ >>mar >>Mar >>MAr >>MAR >>maR >> >>Thanks, >> >>Jarek B. >> >> You could write stored proceudre that will 'up-case' the data in the field i.e. SELECT data FROM table WHERE UPCASE(data)='MAR' create a stored procedure called UPCASE. It may be quite slow though, but atlest it'll work. If you need more help with it let me know. Jamie