Re: Convert char to smallint

SoftTeam Blas Catherine wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_00B6_01BE01CC.1AE89980 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hello, > > I have two fields in two different tables on which I want to make a join = > in my select statement. The problem is that one of two is a char(8) and = > the other one is a smallint.=20 As long as the text column actually only contains numeric strings the engine will make the appropriate conversion automatically. Just join. Art S. Kagel