Home Forums SQL Server 2008 T-SQL (SS2K8) Splitting A String RE: Splitting A String
jarjarlee
SSC Enthusiast
Points: 102
More actions
March 15, 2010 at 6:57 pm
#1134187
You should use a funcation.
define a funcation like
CREATE FUNCTION [dbo].[SplittingByDot]( @SourceData varchar(255))RETURNS NVARCHARASBEGIN......END
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