Re: datatype conversion in SQL???

roger.bruening@metrokc.gov wrote: > I have been reviewing the documentation and cannot find a convert function. That's because it's mostly done implicitly. Try this against the stores database: SELECT 'hello:' || order_date || ':world' FROM orders -- order_date is a date SELECT 'hello:' || total_price || ':world' FROM items -- total_price is a money type In 7.3, there are built-in functions TO_CHAR and TO_DATE (or something like that) as well, although you generally won't need them. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on sushi