>TEXT TO cSqlCommand TEXTMERGE NOSHOW
> IF NOT exists (select COLUMN_NAME from INFORMATION_SCHEMA.columns where table_name = '<>' and column_name = '<>' )
> BEGIN
> alter table <> add <> <> not null default <>
> CREATE NONCLUSTERED INDEX <> ON [dbo].[<>] ([<>])
> 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?
>

<<iif(!empty(tcIndexTag),[CREATE NONCLUSTERED INDEX ]+tcIndexTag,[])>>

Brandon Harker
Sebae Data Solutions