Re: SQL for CONCAT and remove character from certain columns

[manik safo]

Thanks a lot! that really helped :)

my query looks like this now;

SELECT doc_no , doc_type,
CASE
WHEN doc_type = "B" THEN LEFT(doc_no, LENGTH(doc_no)-4)
WHEN doc_type = "A" THEN LEFT(doc_no, LENGTH(doc_no))
WHEN doc_type = "A" || "B" THEN CONCAT("BD/",doc_no)

END AS doc_no
FROM client_document

However the last WHEN statement doesn't work, it should make all doc_no start with BD/