CODEWITHSUNDEEP
c#sqlasp.netsql-server
Loyal
Loyal

Reputation: 823

Check alphabets in SQL Server

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.

Upvotes: 5

Views: 161

Answers (2)

Stanislovas Kalašnikovas
Stanislovas Kalašnikovas

Reputation: 9063

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]);

Upvotes: 8

Tim Schmelter
Tim Schmelter

Reputation: 460238

I assume that you also have a parameter for the current language:

SELECT *
FROM Tbl
WHERE
    ( @language = 'English' AND @name = Name )
OR  ( @language = 'Persian' AND @name = [Persian Name] )

Upvotes: 2

Related Questions