Column Expression

  • Thread starter Thread starter Jim Heavey
  • Start date Start date
J

Jim Heavey

Hello, I am trying to figure out how to specify the property of the
"expression" so that I can create a Data Column which is a computed column.
I thought I could use the SQL Server functions such as RTRIM and Convert
Functions

("RTRIM(CompetitionName) + ' ' + convert(char(10), EventStartDate, 101)")

It does not seem to like either expression. I tried similar expressions in
Query Analizer and they worked just fine.

Am I not able to use the SQL Functions?

Your assistance is greatly appreciated!!!!!!!!!!
 
Jim:

Expression columns support most of the ANSI Sql Functions, but not
everything - and occassionally, the implementation is different. RTRim
isn't supported AFAIK, but Trim is. Here is a link with the supported
operators.

HTH,

Bill
 
Back
Top