I want sql language (like) for select data but data is thai language. I use thai language then not have result.

example sql

assume. --> เมดิ is thai language.

select top 100 RTrim(LTrim(t_nama)) from ttccom100999 where RTrim(LTrim(t_nama)) like '%เมดิ%'

I use this sql but no have result.

really, database have data like '%เมดิ%'

Thank you for answer.

The usage of LIKE has been discussed endless amount of times on this board already, and many solutions been provided. Please search the board before you post a new thread. In general you can use the LIKE operator or dynamic sql.

As for the different language-charachters: I don't see this being a problem.

Well in this case it looks like you are using SQL server sql script and not Baan development tools. In that case searching this forum will probably not help you. So what I will do is move this to the database forum and maybe a SQL server admin can answer your question.

Thank you Mark_h.
I think I go to database forum and maybe a SQL server admin.

I am sorry for this thread. I search any solution before post new thread.

... or you can post your question to Thai language forum on Baanboard: http://www.baanboard.com/baanboard/forumdisplay.php?f=74