Mixed Case Character Data

[TEM3]

I am using DB Explorer to modify data in some Oracle tables. Using the following example to find records:

SELECT * FROM "LABSYS"."ANALYST" "ANALYST" WHERE "ANALYST"."Name" LIKE '%Tra%'

I would like to know if there is SQL syntax to convert ANALYST.Name and my query string ("Tra" in this case) to uppercase, since the data is mixed and some is all uppercase.

 

[LKBrwnDBA]

Try:... WHERE UPPER("ANALYST"."Name") LIKE '%TRA%'


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[TEM3]

Will try. Thanks.

Would:

WHERE UPPER("ANALYST"."Name") LIKE UPPER('%tra%')

work also??

 

[LKBrwnDBA]

Yes.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb