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

Use the IsNull() function, the syntax is the same as the Nz() function

IsNull(YourField,'Value to Convert to')

Great,

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


Paul

You are welcome.