Nick Kewney

Software Architect & Product Builder

Recent Posts

Extracting a price from a VARCHAR in T-SQL

CREATE FUNCTION [dbo].[fn_extract_currency_from_string] (@string VARCHAR(1000)) RETURNS VARCHAR(255) AS BEGIN DECLARE @var VARCHAR(1000) = @string DECLARE @len INT = LEN(@var) DECLARE @start_position INT ,@end_position INT DECLARE

Read More »