Difference between Null and Empty Space

CREATE TABLE EMPLOYEE

(FIRST_NAME CHAR(30) NOT NULL, -- THIS COLUMN WILL NOT ALLOW NULL VALUESLAST_NAME CHAR(30),-- THIS COLUMN WILL ALLOW NULL VALUES NOWAGE INT -- THIS COLUMN WILL ALLOW NULL VALUES NOW )GO-- FIRST SENARIO
-- INSERT EMPTY RECORDS IN THE COLUMN VALUES TO SEE THE DIFFERENCE IN THE RESULTINSERT INTO [TESTING].[dbo].[EMPLOYEE]([FIRST_NAME]
,[LAST_NAME]
,[AGE])VALUES
('','','')GO
SELECT * FROM EMPLOYEE-- RESOLUTION
-- FIRST_NAME : WE USED '' IN THE FISRT ROW.THAT MEANS IT IS INSERTING SOME SPACE.
-- AGE : AS AGE DATATYPE IS INT BY DEFAUL IT WILL TAKE 0 WHILE WE INTSERT NO VALUE.
-- SECOND SENARIO
-- DONT INSERT ANY VALUE IN THE FIRST COLUMN TO SEE THE DIFFERENCE IN THE RESULTINSERT INTO [TESTING].[dbo].[EMPLOYEE]([LAST_NAME],[AGE]
)VALUES
(
'','')GO
SELECT * FROM EMPLOYEE--RESOLUTION
-- FIRST_NAME: AS FIRST NAME IS NOT ALLOWS NULL IT IS THROWING AN ERROR FOR THE ABOVE INSERT QUERY
-- THIRD QUERY
-- DONT INSERT ANY VALUE IN THE LAST_NAME AND AGE COLUMN TO SEE THE DIFFERENCE IN THE RESULTINSERT INTO [TESTING].[dbo].[EMPLOYEE](FIRST_NAME)VALUES
('')GO
SELECT * FROM EMPLOYEE

-- THIS IS THE DIFFERENCE BETWEEN NULL AND EMPTY VALUE IN A RECORDS

Convert Varchar to Money datatype where data ends with "+" or "-" using CASE statment

select
CONVERT(money, CASE WHEN [Column ] LIKE '%-%' THEN '-' + replace([Column ], '-', '')ELSE [Column ] END) AS TransCurfrom
Test_Table

Remove unused zeros or some other data in front of all Records or from Columns data where the data type is VARCHAR

Example:

create table test ([values] varchar(30))go
insert into test values ('000001234')insert into test values ('00000000123456')insert into test values ('000123467') insert into test values ('001234787')insert into test values ('00000001234787')insert into test values ('000012343435')go

SELECTsubstring([values],PATINDEX('%[^0]%',[values]),10) as [values_modified],'Zeroes is Removed' as Removed_Valuesfrom
test