|
|
Posted by NickName on 09/06/05 04:38
I need to remove all the [ and ] in every sql stmt where they are used
to close encircling numeric value, fyi, all these sql stmt are
converted from an Access db. For instance,
select *
from XYZtbl
where fieldA = [1] or fieldA = [2] or fieldA = [3]
to be
select *
from XYZtbl
where fieldA = 1 or fieldA = 2 or fieldA = 3
-- and of course I'd have written in as follows, but that's not
-- the point
select *
from XYZtbl
where fieldA IN (1,2,3)
Thanks.
Navigation:
[Reply to this message]
|