where clause using a variable not working 1

[nsanto17]

I am using the @query Paramater in sp_send_dbmail and for reason i can't use a variable in my where clause

set @Query = 'SELECT     *
					FROM         Email_Log.dbo.Email_Log
						Where ID = (''@Q_ID'')'

its got to be syntax...

Any ideas?

 

[gmmastros]

Depending on the data type of @Q_ID...

If Q_ID is a number...

set @Query = 'SELECT * 
FROM Email_Log.dbo.Email_Log 
Where ID = ' + Convert(VarChar(20), @Q_ID)

Or


if @Q_ID is a string...

set @Query = 'SELECT * 
FROM Email_Log.dbo.Email_Log 
Where ID = ''' + @Q_ID + ''''

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom