jarjarlee (3/15/2010)
You should use a funcation.define a funcation like
CREATE FUNCTION [dbo].[SplittingByDot]
(
@SourceData varchar(255)
)
RETURNS NVARCHAR
AS
BEGIN
......
END
then use the
SELECT dbo.SplittingByDot(OutlineNumber) FROM dbo.Tally
get the result
Other than writing a CLR, it would a lot faster to write an iTVF (Inline Table Valued Function) and then use CROSS APPLY to reference it.
--Jeff Moden
Change is inevitable... Change for the better is not.