Hi Guys..
I am using ASE 12.5 with codepage cp874 (Thai char set id=101) and sort order is IBM dictionary for cp874 (id = 51). I found some problem with widcard query to asking you. for Example.

--- not work ---
create proc p_getname
@name varchar(20)
as
select @name = @name+'%'
select name from table_nm where name like @name
go

The problem is it return 0 row, but when we use below procedure it's work.

--- work ---
create proc p_getname
@name varchar(20)
as
select name from table_nm where name like @name+'%'
go

in 2 example should return same result set

for the first example, it was work in ASE 11.9.2 with codepage iso_1. I am not sure that this problem happen because of codepage or ASE version.

What do you think? What should i do?
Thank you