با سلام
این UDF مشکل شما رو حل مىکنه:
CREATE FUNCTION ssSeparate( @Value as bigint)
RETURNS varchar(15)
AS
BEGIN
DECLARE @Str as varchar(5), @Result as varchar(15)
SET @Result = ''
SELECT @Str = LTrim( Str( @Value % 1000)), @Value = @Value / 1000
IF @Value = 0 GOTO Done -- < 1000
SET @Result = ',' + Right( '00' + @Str, 3) + @Result
SELECT @Str = LTrim( Str( @Value % 1000)), @Value = @Value / 1000
IF @Value = 0 GOTO Done -- < 1'000'000
SET @Result = ',' + Right( '00' + @Str, 3) + @Result
SELECT @Str = LTrim( Str( @Value % 1000)), @Value = @Value / 1000
IF @Value = 0 GOTO Done -- < 1'000'000'000
SET @Result = ',' + Right( '00' + @Str, 3) + @Result
SELECT @Str = LTrim( Str( @Value % 1000)), @Value = @Value / 1000
Done:
SET @Result = @Str + @Result
RETURN ( @Result)
END
صبا صبوحى