>Is there a matching feature in VB.NET 2005 for the VFP of Text/EndText function.
>
>What I'm wanting to do is put the following into a string variable cSQL.
>
>
>
>>declare @ttQueryEnd datetime
>set @ttQueryEnd=convert(varchar(10),@ttStart,101)+' 23:59:59'
>
>SELECT dbo.coper.lastname,
> dbo.coper.firstname,
> dbo.coper.coperid,
> (SELECT Top 1 dbo.corooms.roomname
> FROM dbo.meetings with (nolock) INNER JOIN
> dbo.meetproc with (nolock) ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber INNER JOIN
> dbo.corooms with (nolock) ON dbo.meetings.roomid = dbo.corooms.roomid
> where @ttstart between meetings.BeginTime and meetings.EndTime
> AND meetproc.coperid=coPer.coPerID and meetings.isblock=0 and meetings.iscancelled=0) as RoomName,
> isnull(dbo.coper.isResident,0) as isResident,
> isnull(dbo.coper.isSuspended,0) as isSuspended,
> 0 as Numcancelled,
> 0 as NumSched,
> isnull((Select specdesc from dbo.coSpec with (nolock) where coSpec.specID=coPer.SpecID and coSpec.Isactive=1),' ') as specdesc
>FROM dbo.coper INNER JOIN
> dbo.coperdept ON dbo.coper.coperid = dbo.coperdept.coperid
>where coPerDept.deptID=@tiDept
>and coPer.isactive=1
>and coPer.perTypeID=1
>order by coper.lastname,coPer.firstname
>
Don't know if there is one (I don't use VB.NET and doubt there is), but you could always use a
StringBuilder. That's what I do in C#.
