Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION [dbo].[fn_FormatWithCommas]
- (
- -- Add the parameters for the function here
- @value varchar(50)
- )
- RETURNS varchar(50)
- AS
- BEGIN
- RETURN REPLACE(CONVERT(varchar(20), (CAST(@value AS money)), 1), '.00', '')
- END
Advertisement
Add Comment
Please, Sign In to add comment
