 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / June 2006concatenate true value in iff() function
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 > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.