ah yes works like that, silly me.

thanks for that. i guess there is no possibility for pattern matching, things like suggesting miss spelled words etc. but the suggest list will...

Hey bud

It is one column in which i store the values for all languages. need to search through this column to find similar words after the user types a word....

Try using N'column_name' to retrieve unicode characters.