SPACE()

Description

SPACE(N) Returns a string consisting of N space characters.

Syntax

1. > SPACE(N)

Arguments

Examples

1. > drop table if exists t1;
2. > CREATE TABLE t1
3. (
4. Employee_name VARCHAR(100) NOT NULL,
5. Joining_Date DATE NOT NULL
6. );
7. > INSERT INTO t1
8. (Employee_name, Joining_Date )
9. VALUES
10. ('     Ananya Majumdar', '2000-01-11'),
11. ('   Anushka Samanta', '2002-11-10' ),
12. ('   Aniket Sharma ', '2005-06-11' ),
13. ('   Anik Das', '2008-01-21'  ),
14. ('  Riya Jain', '2008-02-01' ),
15. ('    Tapan Samanta', '2010-01-11' ),
16. ('   Deepak Sharma', '2014-12-01'  ),
17. ('   Ankana Jana', '2018-08-17'),
18. ('  Shreya Ghosh', '2020-09-10') ;
19. > INSERT INTO t1
20. (Employee_name, Joining_Date ) values('     ','2014-12-01');
21. > select * from t1 where Employee_name=space(5);
22. +---------------+--------------+
23. | Employee_name | Joining_Date |
24. +---------------+--------------+
25. |               | 2014-12-01   |
26. +---------------+--------------+