I'm fairly new to all of this, so please bare with me.

I've created a custom control where I can pass an SQL statement to it and this all works.

<iCnt:RC id="clients" runat="server" sSQL="SELECT count(*) FROM vwAdeoClientsNew"/>

but what I want to do is somehow build the sql statement away from the control and then pass it. I know how to do with in ASP

<iCnt:RC id="clients" runat="server" sSQL="<%=MySQL%>"/>

but of course this doesn't work, so how is this done.

Thanks for any help provided

You can assign the value to that property in the codebehind.