string concatenate as where condition in sql2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi All,

I wanted to know if it is possible to concatenate a string as where condition in sql2008, the string must also include the column name(s) of the table for which i am using the where condition. I tried it but was not successful! does anyone know how i can do this?

Thanks and Regards

Posted 11-Jul-11 21:04pm

Roliking

Add a Solution

Comments

Prerak Patel 12-Jul-11 3:12am

Not clear. Elaborate more or show us sample query.

Uday P.Singh 12-Jul-11 4:17am

post your query, so that we can help you.

Roliking 12-Jul-11 4:31am

the query is something like this, the statement that i want to execute is a string which is dynamically created

declare @Fil as varchar(100)
set @Fil= 'from tbl_Accountmaster'
select + @Fil

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nthaomei · Answer 1 · 2011-07-11T23:06:00

Solution 3

Can you use like this? -

SQL

declare @Fil as varchar(100) set @Fil= '* from yourTable' ;
declare @qury as varchar(200) set @qury='Select ' + @Fil
exec (@qury)

Posted 11-Jul-11 23:06pm

nthaomei

Updated 11-Jul-11 23:10pm

v4

Comments

nthaomei 12-Jul-11 5:21am

Please make me known if it is helpful.

Roliking 12-Jul-11 8:22am

Thanks it was helpful! I found out one more way to do it using sp_executesql
which is similar to exec()

Thanks anyways...

Abhinav S · Answer 2 · 2011-07-11T23:38:00

Solution 4

Some good info on dynamic where clauses at Implementing Dynamic WHERE-Clause in Static SQL[^].

Posted 11-Jul-11 23:38pm

Abhinav S

nthaomei · Answer 3 · 2011-07-11T22:14:00

Solution 1

It would be helpful if you provide a piece of code containing the query.

Posted 11-Jul-11 22:14pm

nthaomei

Comments

Roliking 12-Jul-11 4:30am

the query is something like this, the statement that i want to execute is a string which is dynamically created

declare @Fil as varchar(100)
set @Fil= 'from tbl_Accountmaster'
select + @Fil