Viewing 3 posts - 166 through 168 (of 168 total)
Ron,
I think the two columns (AreaCode & PhoneNumber) are of type int, thats why concatenation is not happening
try this
update
PhoneTable
set
AreaPhone =
August 17, 2006 at 10:56 am
#655498
sorry misspelt use
([dbo].[GetCount]([Location]))
in formula field
August 16, 2006 at 4:55 pm
#655355
To achieve this there are two ways (probably more)
By Creating trigger or By Creating an User Defined function and making the column as computed using the function call as formula...
August 16, 2006 at 4:53 pm
#655354