Date: Sun, 2 Nov 2008 23:16:40 -0600
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: Select Statement
Content-Type: text/plain; charset=ISO-8859-1
You need to convert height to a non-string parameter, or else deal with it
in a converted manner, such as using substring with find or split to
determine if the height matches the necessary rule.
In general, though, you should store height as a number. Number of inches
is probably easiest (12*feet + inches).
On Sun, Nov 2, 2008 at 7:43 PM, <firstname.lastname@example.org> wrote:
> I am giving this sql quey
> SELECT * FROM table WHERE gender = ? and age between '18' and '40' and
> profile.hieght>= '4.10'And profile.hieght<='5.11' order by
> firstname .
> and I didn't got exactly records ( unable to handle height coz may be
> in . (e.g. 5.11 ), can some one help me !