Hello there,

I'm developing an application and have a number of requirements where
I am trying to do quite a few financial calculations on a number of
fields. I have gone against trying to store these as computed
columns, and have tried views, but meet the problem that the maximum
character length of an alias is 128 characters. Can anyone advise me
as to another way around this.

The maximum length of an alias is 128 characters, same as for any other
identifiers. I don't understand why this would be a problem unless you
are using some poorly chosen names. Why isn't 128 characters enough for
you?

--
David Portas
SQL Server MVP
--

I don't think you mean "alias" (correlation name) at all. Maybe you
could explain with an example exactly what limitation you are finding a
problem with.

--
David Portas
SQL Server MVP
--