@ sysmbol in SP paremeter ?

• SteveB-74825

  Hall of Fame

  Points: 3290

  More actions

  June 7, 2004 at 7:56 am

  #160961

  if i have the following simple query

  select * from Program where Executable = 'Psuedo program'

  this works fine

  if i have another entry in Program with Executable set to '@Psuedo program'

  and then try

  select * from Program where Executable = '@Psuedo program'

  this returns nothing ...

  any idea why ?

  ***********************   update - ************************************

  the values seem to be different in the database

  i have cast both values as varbinary and got the following results

  parameter >              0x40506172616D44657461696C732020676F

  value in database >    0x40506172616D44657461696C730D0A676F

  they look identical (i have done the ltrim(rtrim( thing)

  any ideas ?

   

  cheers

  dbgeezer

• Bavineni

  SSC Enthusiast

  Points: 147

  More actions

  June 7, 2004 at 8:38 am

  #509256

  Try using

  select * from Program where Executable = @Psuedo program

   

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  June 7, 2004 at 8:46 am

  #509260

  @ identifies a variable, so SQL Server is confused when you are using at the beginning of a string.

  The single quotes should work, but try this instead:

  [@psuedo program]

  -SQLBill

• SteveB-74825

  Hall of Fame

  Points: 3290

  More actions

  June 7, 2004 at 9:05 am

  #509267

  it turned out there were \r\n chars in the database ...

  cheers

  dbgeezer