>- see footer for list info -<
Morning,
A quick SQL question to keep your minds sharp before the weekend!
I have 2 columns, FromBeds, ToBeds in an SQL db and I want to find the records
where my value falls between those values.
So if I search for a property with 3 bedrooms I want to find all the properties
which fall in that range.
This didn't work.
SELECT *
FROM Table
WHERE FromBeds >= #val(beds)# AND/OR ToBeds <= #val(beds)#
Thanks
Allan
---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
