Hi-
I've got some issues with the ordering of search results. I've got 4
fields, (a, b, c, d). Most often there is data in field a. Sometimes
there isn't and so then I'd like to look at field c.
I can accomplish most of what I want with this:
select
a as location1, ISNULL(SiteCity, SiteCityOther) AS location1,
ISNULL(SiteCityOther, SiteCounty) AS location1, ISNULL(SiteCounty,
SiteCountyOther)
AS location1,