mjahkoh Posted January 21, 2010 Share Posted January 21, 2010 Why would i construct a concat as below concat (a,b , if (z=1,'c','cc'), if(y=1,'d','dd') ) where the results of if (z=1,'c','cc') and if(y=1,'d','dd') are added to the string depending with their results. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 21, 2010 Share Posted January 21, 2010 Huh? Are you asking why you would do it? How would I know? Quote Link to comment Share on other sites More sharing options...
mjahkoh Posted January 25, 2010 Author Share Posted January 25, 2010 How would i construct a concat as below concat (fielda,fieldb , if (fieldz=1,'cat','dog'), if(fieldy=1,'dog','mouse') ) the concat is ok without the ifs and appends the result of evaluating if (fieldz=1,'cat','dog') and if(fieldy=1,'dog','mouse') ) to fielda and fieldb Thanks in advance Quote Link to comment Share on other sites More sharing options...
fenway Posted January 28, 2010 Share Posted January 28, 2010 I'm sorry, I don't follow -- maybe someone else will help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.