My table has a Boolean cell for “Family” . I want to make a query with a column that says “and Family” if TRUE and " " if FALSE. I tried to create a compound REPLACE function but it didn’t work. I can only do one or the other. This query is to provide a CSV file for an external emailing function with other data from the table.
Any suggestions for overcoming this?
Thank you in advance,
Joe
Add to your existing query:
SELECT CASEWHEN("Family" = 'TRUE','and Family', '') SUBSTITUTE FROM "YOUR_TABLE"
Perfect. Worked Great. Thank you Ratslinger.
You continue to help me grow.
If this answers your question please click on the (upper left area of answer).
@JoeCastor First, always glad to help. Questions are always welcome.
While marking a question closed is OK, it can be closed for many different reasons. Marking that a correct answer was provided helps others who are looking for answers to the same or a similar question. This is done in the upper left of the correctly provided answer - see this post.