This is a multi-part message in MIME format.
------=_NextPart_000_0144_01C82C31.FBB67EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
Having a little issue, and can't seem to figure it out!
Every time I try to run this select command I get this error:
select left(kd_aln,2) as code from airlin
the error msg is : function left(character varying, integer) does not =
exist
How to resolve this problem
Thank for your attention
Regards
Nyoman/Bali
------=_NextPart_000_0144_01C82C31.FBB67EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
<DIV>
<P dir=3Dltr><FONT face=3DArial><SPAN lang=3Den-us>Having a little =
issue, and
can</SPAN><SPAN lang=3Den-us>=92</SPAN><SPAN lang=3Den-us>t seem to =
figure it
out!</SPAN></FONT></P>
<P dir=3Dltr><SPAN lang=3Den-us><FONT face=3DArial></FONT></SPAN></P>
<P dir=3Dltr><FONT face=3DArial><SPAN lang=3Den-us>Every time I try =
to</SPAN><SPAN
lang=3Den-us> run this select command I get this =
error:</SPAN></FONT></P>
<P dir=3Dltr><SPAN lang=3Den-us>select left(kd_aln,2) as code from =
airlin</SPAN></P>
<P dir=3Dltr><SPAN lang=3Den-us>the error msg is : function =
left(character varying,
integer) does not exist</SPAN></P>
<P dir=3Dltr><SPAN lang=3Den-us>How to resolve this problem</SPAN></P>
<P dir=3Dltr><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Thank for =
your
attention</FONT></SPAN></P>
<P dir=3Dltr><SPAN lang=3Den-us><FONT face=3DArial =
size=3D2>Regards</FONT></SPAN></P>
<P dir=3Dltr><SPAN lang=3Den-us><FONT face=3DArial
size=3D2>Nyoman/Bali</FONT></SPAN></P></DIV></BODY></HTML>
------=_NextPart_000_0144_01C82C31.FBB67EC0--
