asked on 5/23/2012

SQL query search

HI friends
I have function GetValue( string id)
I am passing id=abcd
I want to assign to a variable if abcd is present in the databse
but abcd is stored as abcd@MCKTESTAD.local
in database. I want to search the database exactly the row which contains
id@(abcd ) in the beginning and assign that value to variable. How can I do that

Application Servers C#Microsoft SQL Server

Last Comment

banu111

5/23/2012

ASKER CERTIFIED SOLUTION

Aneesh

5/23/2012

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Anuradha Goli

5/23/2012

To get data from SQL Server which matches string starts with ''id@(abcd )' is:

Declare @data nvarchar(50)
set @data = 'abcd@MCKTESTAD.local'
SELECT * FROM TableA WHERE COLUMN1 LIKE 'id@(abcd )%'

Open in new window

Aneesh

5/23/2012

You should probably change your Grading strategy. I hope i gave you the perfect answer.

banu111

5/23/2012

ASKER

but if have two users abcd@MCKTESTAD.local and abcd@MCKTESTAD.local will it wrk

banu111

5/23/2012

ASKER

sry abcd1@MCKTESTAD.local