Stringy problem

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  March 18, 2003 at 1:12 am

  #357728

  When I run

  use northwind

  DECLARE @CharVariable CHAR(9)

  SET @CharVariable = 'Beverages'

  select * from categories where categoryname = @CharVariable

  in Query Analyzer (sql 2k) everything works fine. But if I change the last line to read

  exec('select * from categories where categoryname =' + @CharVariable)

  I get

  Server: Msg 207, Level 16, State 3, Line 1

  Invalid column name 'Beverages'.

  What am I doing wrong?

  TIA,

  Bill

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 18, 2003 at 1:43 am

  #451312

  You're missing quotation-marks.

  use northwind

  DECLARE @CharVariable CHAR(9)

  SET @CharVariable = 'Beverages'

  exec('select * from categories where categoryname = ''' + @CharVariable + '')

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/