Hi,

I have a memory variable created with TEXT TO. But I want a certain line within the TEXT TO to be optionally included or removed.

For example:

TEXT TO cSqlCommand TEXTMERGE NOSHOW
	IF NOT exists (select COLUMN_NAME from INFORMATION_SCHEMA.columns where table_name = '<<tcTableName>>' and column_name = '<<tcFieldName>>' ) 
		BEGIN
			alter table <<tcTableName>> add <<tcFieldName>> <<tcFieldType>> not null default <<tuDefault>>
			CREATE NONCLUSTERED INDEX <<tcIndexTag>> ON [dbo].[<<tcTableName>>] ([<<tcFieldName>>])
	        SELECT CAST(1 AS bit) AS col_added
	    END    
	ELSE 
		SELECT CAST(0 AS bit) AS col_added
ENDTEXT

But above I want the line CREATE NONCLUSTERED INDEX .. to be in the resulting cSqlCommand if the value tcIndexTag is not empty.

How do I do it?

TIA

UPDATE. I will have to create two different TEXT MERGE based on the value of the variable. I was hoping for more efficient approach.