if you use field type 'char', it will treat any empty characters as a space, and thus having all the spaces in your email. Change the field type to 'varchar'...

That means still creating a temp table and returning the temp table instead.

If that's the case I'll have to do it that way...

Well, the function can take the record type as the variable. But I don't mind creating views for each different type of record, however, the number of extra fields for...

Thanks Ian! I didn't remember that UDF can return a table.

I've done some test, can't seem to get what I want. Problem is with the UDF, the Inline table-valued function...

Stay away from Razr! I regretted my decision to take that phone when I renew my contract. The shape and size and weight is good alright, but the menu is...