UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Joining null strings in a view    
 
   
gbdavisa
post May 23 2006, 03:40 PM
Post #1

New Member
Posts: 13
I want to create a view showing the contact's name as Surname, Title Intials and this works fine in Access, even when there is no data for initials or title. In SQL Server 2000 though, it would appear that the NULL entry for, say, Initials causes the who expression to be returned as Null i.e. Surname + ' ,' + Title + Initials

Is there the equivalent of NZ( ) as you could use in Access or a better way of creating the list of user names?

Thanks


Paul
Go to the top of the page
 
+
truittb
post May 23 2006, 05:08 PM
Post #2

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
Use the IsNull() function, the syntax is the same as the Nz() function

IsNull(YourField,'Value to Convert to')
Go to the top of the page
 
+
gbdavisa
post May 24 2006, 01:42 PM
Post #3

New Member
Posts: 13
Great,

Thanks for your help. I'm off to start coding again.


Paul
Go to the top of the page
 
+
truittb
post May 24 2006, 01:48 PM
Post #4

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
You are welcome.
Go to the top of the page
 
+
« Next Oldest · Microsoft SQL Server · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 12:45 PM