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
Comments: To: oshoinfosys@gmail.com
In-Reply-To:  <607c611f-d77e-4ecb-954a-f196cfa334e9@q30g2000prq.googlegroups.com>
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).

-Joe

On Sun, Nov 2, 2008 at 7:43 PM, <oshoinfosys@gmail.com> 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  !
>