Base: Query, compound REPLACE function

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 :heavy_check_mark: (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.