Display first letters of a name and last name

Good day. How can I display first letters of a name and last name like in the picture that I attached below. I’m getting the names from a database that I saved online (restdb)

Hi, do you have the full name in a string "Claudia Abrahams" or separate firstName and lastName fields?

In case of separate fields the answer is pretty straightforward, you can use TRUNCATE(firstName, 1, "") to get the first character.

So TRUNCATE(firstName, 1, "") + TRUNCATE(lastName, 1, "") will give you the initials.

However if the whole name is in one variable, you need to use SPLIT(fullName, " ") first to get the two strings in a list, and then do the TRUNCATE operation for both.