InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 21:17:23 GMT20http://www.sqlservercentral.com/Forums/Topic1394667-364-1.aspxFortunately the 4000 character limit is an expression limitation, not a limitation of the number of characters in the string. I have not done this personally but you might be able to break your expression down into parts and set a variable to each section. For example Var1, Var2, Var3, SQLVar. ThenVar1 = SELECT........Var2 = FROM.....Var3 = WHERE....SQLVar = Var1 + Var2 + Var3If that doesn't work the other way is to pull the query as suggested above from SQL built as a stored procedure, or from a column in a table that stores the entire query, and then set your variable value to the string returned.Tue, 11 Dec 2012 07:07:33 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1394667-364-1.aspxReplace the string expression with either a code object or a stored proceduring, depending on what you are trying to do with it.Mon, 10 Dec 2012 09:23:10 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1394667-364-1.aspxHi all, I have a query more than 4000 characters limit .I am setting with variables to the query.while i used the string expression i am getting error like string expression is limited to 4000 characters limit.Is any one have idea about how to eliminate the length limit in expression.Mon, 10 Dec 2012 08:50:48 GMTvasamsettipradeep