SQL issue....

[Brad Pears]

I am trying to use a generic SQL clause to select a description field from a
table. The problem is that a lot of the descriptions include measurement
values - i.e. ' is for foot , " is for inches. Some descriptions include
both as follows...

Interior Doors_3'0 x 6'8 Pine door slab 1 3/8"

How do you select a description like this using SQL? Placing quotes around
the description will screw up as will placing single quotes around it...

Any suggestions?

Thanks,

Brad

 

[Marshall Barton]

I am trying to use a generic SQL clause to select a description field from a
table. The problem is that a lot of the descriptions include measurement
values - i.e. ' is for foot , " is for inches. Some descriptions include
both as follows...

Interior Doors_3'0 x 6'8 Pine door slab 1 3/8"

How do you select a description like this using SQL? Placing quotes around
the description will screw up as will placing single quotes around it...

I don't think I understand what you're driving at here. I'm
far from sure, but maybe you want to use this kind of
condition:

.. . . descr =""" & Replace(txtDescr, """", """""") & """"