The Carter Family Band
|
|
Schedule of Events
Date |
Event Name
(click for event details) |
Location |
sql=select * from ggevent where groupid='thecarterfamilyband' and datemmm > ' ' and dateyyyy > ' ' and datedd > ' ' and timehh > ' ' and venue > ' ' and city > ' ' and state > ' ' and zip > ' 'and title > ' ' order by cast(datemmm+' '+datedd+' '+dateyyyy+' '+timehh+':'+case when timemm <= ' ' then '00' else timemm end+case when len(timeampm) > 0 then left(timeampm,1) else 'A' end +'M' as datetime) |
|