Private: Code & Script Snippet

class=”brush: c-sharp; ”

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace WindowsFormsApplication1
{
/* test hilighter */
class ClassAddress
{
public string Name { get; set; }
public string Street1 { get; set; }
[...]

Try this :

Select * from Table1 WHERE (ColumnName like N’%Values%’)

Select * from Table1 WHERE (ColumnName = N’%Values%’)

or

Select * from Table1 Where (ColumnName collate Thai_bin like N’%Values%’)

Select * from Table1 Where (ColumnName collate Thai_bin = N’%Values%’)