Dear ALL,

I wanna make a query to search the name pattern without considering case-sensitive, but it doesn't work. Can anyone help me, pls?


string search(100)
search = "%" & given.name & "%"

select tccom140.*
from tccom140
where
tolower$(tccom140.chrn) ALIKE tolower$(:search)
selectdo
endselect

P.S. given.name is a field variable to hold the searching pattern.

Does using ALIKE instead of LIKE lower the system performance???

Does using ALIKE instead of LIKE lower the system performance???...If yes then how to improve it?