Date-based query Q

table with a row for every day under the sun in it, against which you could inner join the main query, but I'm not keen on that (that is just a gut response though). Any ideas? Thanks! -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0

RE: Date-based query Q

Thanks for everyone's help with this one, btw. In the end I bit the bullet and added a dates table. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards

Dump table to file, edit and reimport

is no, is OMS easy to set up? Thanks! -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service

RE: Restricting the range of values in a field

. In the main, I absolutely agree (i.e. I don't think lookup tables are inherently bad). However, in this particular instance, the check constraint is a perfect solution (I won't bore you with the reasons why). -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental

RE: Restricting the range of values in a field

where the range of values are known to be static and he'd shout at me ;-) Thanks again! -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 This e-mail has been

Restricting the range of values in a field

what can be entered at the database level, in case other means of entering data are ever used or if the application layer fails, for whatever reason, to trap an unwanted value. Thanks -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695

Right()

to be desired? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered

RE: Right ()

order by to_number(substr(lt_tk_id,length(lt_tk_id)-1)) Brilliant. Thanks to everyone that mentioned substr. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775