Check alphabets in SQL Server

Question

I am developing a website in asp.net (C#) having two languages "English" and "Persian". I have a search field in front end and I want to pick the English name when I do search in English and to pick the Persian name when I do search in Persian.

I have record in table in the following format:

===========================
   Name     |Persian Name|
===========================
Faridullah  |    فریدالله   |

I have a search field in front end. So I want to pick "Name" when I enter English alphabet and when the language is changed means when I enter Persian alphabet Persian name should be picked. so how could I do that in a query.

Answer 1

You can simple use OR in your WHERE clause in following:

SELECT *
FROM Tbl
WHERE @name = Name OR @name = [Persian Name];

Or slightly shortened

SELECT *
FROM Tbl
WHERE @name IN (Name, [Persian Name]);