upper

Magno

Hi,

I know with sql you can use upper and lower in your sql statement like:
sql = "select * from tbl where upper(field)='" & ucase(value) & "'"

i just can't make it work with codbc, could anyone help me on this one?
i want to make login non case sensitive, but i can't change fields in navision, so it has to be done in asp code

Mark_S

try:

UCASE (string_exp)