whenever creating view with the below condition i am not getting any value in the view .
1.the table contains encoded japanese characters. it was stored as special characters like ? and * in table.
2.i am trying to create a view using the following query
"CREATE VIEW [view-name] WITH SCHEMABINDING AS (SELECT "table-name"."attribute" FROM "table-name" WHERE (( ISNULL("table-name"."attribute",
' ') = '漢字漢字漢字漢字漢' )))"
3.table in the view is not containing any value for the attribute(the select command does not return anything)
4.whenever i use > symbol instead of = its return some value from the table (< and = operators does return any value in select command)
can anyone please help me out .
Moderator's, this is a duplicate of
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?