Theatre

Plays



Script:/theatre/Plays.asp
Description:The connection cannot be used to perform this operation. It is either closed or invalid in this context.
SQL Statement:SELECT DISTINCT UPPER(left(case when left(PlayName,2)='A ' THEN right(PlayName,len(PlayName)-2) when left(PlayName,3)='An ' THEN right(PlayName,len(PlayName)-3) when left(PlayName,1)='''' THEN right(PlayName,len(PlayName)-1) when left(PlayName,4)='The ' THEN right(PlayName,len(PlayName)-4) else PlayName END ,1)) AS PlayStrip FROM tbl_nt_Play WHERE left(PlayName,1)>='A' and left(PlayName,1)<='Z' order by PlayStrip
Source:ADODB.Recordset
Error Number:3709