MySQLString FunctionsSPACE
HEX

SPACEString Functions

ABS

Returns a string of n spaces.

Syntax

SPACE(n)

Example

Enter values below to update the example in real time.

first_name
last_name
full_name
employees
SELECT CONCAT(first_name, SPACE(1), last_name) AS full_name
FROM employees;