SQL Question

kayos

You want something like this

select P.personal_id
from personal P
where UPPER(P.nickname) LIKE '%'+UPPER(@Name) +'%'

The case sensetivity is a server setting and if you have your db server set to being cases sensitive you have to re-install it.

Kayos

The above applies to MS SQL Server (I dont really no about other servers)

The_Elf

I have an sql query something like this

select P.personal_id
from personal P
where P.nickname LIKE '%'+@Name+'%'

so if @Name = 'lex'
it returns Alex, Alexander etc etc....

my question is it possible to make the search case insensitive so that it returns
names entered as ALEX, AleXaNdEr

i have no idea how to do this couldn't find anything on the web either

dogs

I ran into a similar problem before. Turned
out that if the value being searched for
was mixed case, it was a case-sensitive
search, but if it was all lower-case, it
was a case-insensitive search. So a quick
change of case before you query solved it
for me. Bug / Feature ? I dunno, never
did read the docs