This function does look great if you know your variable in advance. But, that's why EVALUATE() is so powerful, because you don't have to know the variable in advance, you can pass a string "name" to it and it will evaluate it. For example:

x = "company.name"
y = EVALUATE(x)
? y && Displays... ABC Company

So the $64 question is, is there anything like that in C#?

bob


>You can use the StringBuilder class:
>

>StringBuilder sb = new StringBuilder();
>sb.Append("SELECT *");
>sb.AppendFormat(" FROM {0}",YourTableName);
>sb.AppendFormat(" WHERE cName LIKE '{0}%'", WorkGroup);
>sb.AppendFormat(" AND dIntervalStart >= '{0}' AND dIntervalStart < '{1}'", StartDate, EndDate);
>sb.Append(" GROUP BY cName");
>string sql = sb.ToString();
>
>SqlConnection cn = new SqlConnection(SqlDataSource);
>SqlCommand cm = new SqlCommand(sql, cn);
>