Re: [GENERAL] convert from access

2000-08-31 Thread Joel Burton
> I have to remake PHP script (which full of Access SQL implementation) > for PostgreSQL. I have a some of strings like this: > > SELECT memmod.item, memmod.oempartno, memmod.sdescr > FROM memmod WHERE (InStr(1, [item], '".$edtPartNo."'));"; There are programs to help you move Access *tables* t

[GENERAL] convert from access

2000-08-31 Thread Sergei Karasiov
I have to remake PHP script (which full of Access SQL implementation) for PostgreSQL. I have a some of strings like this: SELECT memmod.item, memmod.oempartno, memmod.sdescr FROM memmod WHERE (InStr(1, [item], '".$edtPartNo."'));"; How can I convert this string for PostgreSQL? --