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

concatenate true value in iff() function

P: n/a
i am trying to put a space between title_the and title ONLY if title_the is
not null. below is what i have, but it is returning the empty space
regardless of whether the value is null or not. ideas? thanks!

iif(title_the is null, '', [title_the] & ' ') +''+ title as movie
Jun 4 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Goomba wrote:
i am trying to put a space between title_the and title ONLY if title_the is
not null. below is what i have, but it is returning the empty space
regardless of whether the value is null or not. ideas? thanks!

iif(title_the is null, '', [title_the] & ' ') +''+ title as movie

iif(IsNull(title_the), "", [title_the] & " ") & title as movie
Jun 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.