By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,362 Members | 3,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,362 IT Pros & Developers. It's quick & easy.

Combining Fields to string

P: 17
I have a function that takes a field with values separated by commas within the field and splits them to multiple rows.

Example:
Field - Interior
Value - abc,def,efg,ghi

Output:
ID Item
1 abc
2 def
3 efg
etc

This is working great thanks to help that I received on here.

Now I am combining multiple fields to a string.
Example:
Field1: abc, def
Field2: ghi, jkl

using

SELECT (Field1 + ',' + Field2) From .....

This is working great unless there is a field that has a NULL value. Then I get a NULL result.

Is there an easy way to only put the fields with value into my string and leave out the NULL fields? Some have one NULL field, some have multiple. I just need to get the string to work and get only the fields that have values.

Any suggestions are always appreciated.
Apr 4 '07 #1
Share this Question
Share on Google+
2 Replies


P: 17
It has been resolved on another post.

THANKS!!
Apr 4 '07 #2

P: 1
It has been resolved on another post.

THANKS!!
I am having the same problem - can you tell me what other post solved the issue?

Thanks in advance

RIP
Jun 27 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.