Hi,
can anyone please try to filter the following data using rowfilter an
see whether it works or not.
Note: Have to escape [ and ].So, [ is written as [[] and ] is writte
as []]. All the data is stored as NVARCHAR not VARCHAR.

i'm using visual basic.net V1.1.

When the data are stored as unicode, the rowfilter works properly
However, when the data are stored
as NVARCHAR, the rowfilter is not working properly. Is is it becaus
the data are stored as
NVARCHAR that makes rowfilter doesn't works properly?

Three records in the database are:
1# [1222 -220
ภาษาไทยเพื่อการสื่อสาร]
3# [1212 - 220
วิทยาศาสตร์พื้นฐา&#3609
]
12# [1122 - 320
วิถีธรรมวิถีไท&#3618
]

Let say i want to get the third record with one of the string below,
can get the desired data.
'%12%'
'%12#%'
'%[[]%'
'%[]]%'
'%[[]1122%'
'%[[]1122 - 320
วิถีธรรมวิถีไท&#3618
[]]%'
'%#%'
'%-%'
'%วิถีธรรมว%'


However, i can't get the third record if i use one of thestring below.
'%# %' (a space after #)
'%# [[]%'
'%12# [[]%'
'%12# %' (a space after #)
'%# [[]1122%'
'%12# [[]1122 - 320
วิถีธรรมวิถีไท&#3618
[]]%'


Can you help me?

You can reply to my gmail account heng81 (AT) gmail (DOT) com.
Thank

--
ahoo