troubleshooting Question

Negative isnull?

Avatar of Nigel Keith-Walker
Nigel Keith-WalkerFlag for Australia asked on
Microsoft SQL Server 2008
3 Comments1 Solution244 ViewsLast Modified:
I have a stored procedure that selects details from a customer file to build a full name and full address.
The select statement interposes spaces and commas into the full address.
ALTER  PROCEDURE [dbo].[sp_Name_Addr] 
	AS
	SELECT 
(isnull([FirstName],'') +' '+	ISNULL([LastName],'')) as Fullname, 
(ISNULL([StreetNumber],'') + ' ' + ISNULL([Address],'')+','+ ISNULL([Suburb],'')+','+ISNULL( [PCode],'')+','+ ISNULL([State],'')+','+ ISNULL([Country],'')) as FullAddr,[ID], [Status]
FROM [tblCustomer]
Where Firstname is Not null
and Status <> 'Expired'
ORDER BY Fullname
Some of the addresses have null in street number.  This means that the full address commences with a space.  
Tried to put NOT isnull(streetNumber,' ') into the select statement but the NOT is not accepted.
Any suggestions?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros