@patelmohamad : Name like '_ohn%' is not working. I am using following query

Me using : SELECT * FROM tblNames WHERE CONTAINS(Name, '*ohn*') -> No result returns

...