>I like Ted Roche's approach, but have you tried CAST()? I hadn't. Ted's query runs faster than mine, though, and, apparently, it's more accurate (returns actual values for artist in places where my query returned nulls). I don't know why that is, though, and I also don't know why, separate from the accuracy issue, my IFNULL() wrap generated an error.
>BTW, here's a way to make your query more readable which may help you >with future queries. > >TEXT TO artfield TEXTMERGE NOSHOW Thanks for that tip also. Ken www.stic-cil.org -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007 9:41 AM _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
