Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT

MarkPryceMaherMSFT/check_my_decimal.sql

Created April 1, 2022 17:36
Show Gist options
  • Save MarkPryceMaherMSFT/f3fc3448b0c727fde32d584b00055a29 to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/f3fc3448b0c727fde32d584b00055a29 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
check_my_decimal.sql
create FUNCTION dbo.check_my_decimal (@value varchar(255))
RETURNS decimal(18,2)
as
BEGIN
declare @rt decimal(18,2)
set @rt = try_parse(@value as decimal(18,2))
return @rt;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment