kevindb/f_nullForBlank.sql

Created July 6, 2016 18:52

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kevindb/02dde260366988dc95948643eb748162.js"></script>
Save kevindb/02dde260366988dc95948643eb748162 to your computer and use it in GitHub Desktop.

Download ZIP

SQL Server function to return NULL for blank columns

Raw

f_nullForBlank.sql

	CREATE FUNCTION [dbo].[f_nullForBlank]
	(
	@value VARCHAR(8000)
	)
	RETURNS VARCHAR(8000)
	AS
	BEGIN
	RETURN NULLIF(LTRIM(RTRIM(@value)), '')
	END

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment