Hi,
can anyone please try to filter the following data using rowfilter and see whether it works or not.
Note: Have to escape [ and ].So, [ is written as [[] and ] is written 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 tehd ata are stored
as NVARCHAR, the rowfilter is not working properly. Is is it because the data are stored as
NVARCHAR that makes rowfilter doesn't works properly?

Three records in the database are:
1# [1222 -2201 ÀÒÉÒä·Âà¾×èÍ¡ÒÃÊ×èÍÊÒÃ]
3# [1212 - 2200 ÇÔ·ÂÒÈÒʵÃì¾×é¹°Ò¹ ]
12# [1122 - 3201 ÇÔ¶Õ¸ÃÃÁÇÔ¶Õä·Â ]

Let say i want to get the third record with one of the string below, i can get the desired data.
'%12%'
'%12#%'
'%[[]%'
'%[]]%'
'%[[]1122%'
'%[[]1122 - 3201 ÇÔ¶Õ¸ÃÃÁÇÔ¶Õä·Â []]%'
'%#%'
'%-%'
'%ÇÔ¶Õ¸ÃÃÁÇ%'


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 - 3201 ÇÔ¶Õ¸ÃÃÁÇÔ¶Õä·Â []]%'

I think that the reason the rowfilter can't get the correct record is because the # is the reserved word.So, i'm finding the escape letter for #. I can't find any help in MSDN. I also tried [#] and \# but they didn't work.

Can you help me?:(