Informix to MS SQL 2005

Posted in 2006

↪ replying to maxskalski@gmail.com

Jean Sagi — Wed, 16 Aug 2006 06:03:11 +0000 — source: Usenet: comp.databases.informix

A substring will do. J. maxskalski@gmail.com escribi': > Hi! > How to convert this condition (Informix) to MS SQL? > > account[1,3] <> '215' > > account is in the table as char[10] > > Thanks in advance, > Max > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

maxskalski@gmail.com — 16 Aug 2006 01:12:18 -0700 — source: Usenet: comp.databases.informix

Hi! How to convert this condition (Informix) to MS SQL? account[1,3] <> '215' account is in the table as char[10] Thanks in advance, Max

↪ replying to maxskalski@gmail.com

bozon — 16 Aug 2006 07:15:11 -0700 — source: Usenet: comp.databases.informix

i think this works just like this in informix. maxskalski@gmail.com wrote: > Hi! > How to convert this condition (Informix) to MS SQL? > > account[1,3] <> '215' > > account is in the table as char[10] > > Thanks in advance, > Max