0

One of my column in sql table contain values like

$$ADC.ES%32,A

How can I match this in my select where clause?

Select .... From .... Where ColumnName = '$$ADC.ES%32,A'

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
mushtaqck
  • 77
  • 2
  • 6
  • what happens if you execute that query? i think it seems fine since you are not searching for pattern. – John Woo Jan 12 '13 at 09:22
  • 1
    it should find it, see this, http://sqlfiddle.com/#!3/ae7a5/1 – John Woo Jan 12 '13 at 09:24
  • unless the actual value in the table is a UNICODE or binary string that is when displayed in the result window gets converted to $$ADC.ES%32,A. Also, %32 part of the result suggests that you use some sort of HTML query analyser. %32 most likely is a space. Try Where ColumnName = '$$ADC.ES ,A' and see what happens – cha Jan 12 '13 at 09:51

1 Answers1

0

it should find with your query any way try this

select * from table where name like '$$ADC.ES%32,A'

vidyadhar
  • 3,118
  • 6
  • 22
  • 31