where statement?

raysefo · #1 (**permalink**) 06-12-07, 14:47

Hi,

I have a varchar field and in this field there may be chars like 'A','C' etc. or strings like "A-C", "A,C,H" etc or just decimal numbers like '0.4','4.2'.

What i want to do is, just check for decimal numbers and which are bigger than 4.0.?

here what i wrote but gives error:

...

where left(RESULT,1) not between 'A' and 'Z' AND
DECIMAL(SONUC) >= 4.0

Peter.Vanroose · #2 (**permalink**) 06-12-07, 16:26

Quote:

Originally Posted by raysefo

What i want to do is, just check for decimal numbers and which are bigger than 4.0.?

What about:

Code:

...
where left(RESULT,1) between '4' and '9'
   or   (left(RESULT,1) between '1' and '3'
          and substr(RESULT,2,1) between '0' and '9')

ARWinner · #3 (**permalink**) 06-12-07, 16:27

Yes, the DECIMAL will bomb when the data is non-numeric.

Check out this recent thread, it may help you.

A fun little ORDER BY problem (sorting char field)

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech