SQL Interview Query | How to pad zeroes to a number | LEFT 

Could I recommend to all viewers that you do not use '+' to concatenate items. It is a mathematical operator, and if you are unaware of the data types you are working with it can lead to errors and a lot of debugging. It was standard practise ten years ago, then SQL2012 gave us the CONCAT() function which also converts any input to a string. In the example given in the video the @var was created as a 'varchar' however in your own data it would be far more likely stored as an 'int', wherein this query will return an error. You will in your professional life often see legacy code using the method detailed above, however try not to get into bad habits so early in your learning, and don't be afraid to correct existing codebases and implement coding standards. So if you're working on SQL Server since 2012, which really you should be, then use CONCAT(). The FORMAT() option described elsewhere has the same (but inverse) problem, being as FORMAT() will not work with string datatypes Using CONCAT() is datatype agnostic and therefore a far better habit to be in. See example below DECLARE @var1 VARCHAR(5) = '23' DECLARE @var2 INT = 23 SELECT RIGHT(CONCAT('0000',@var1),4) SELECT RIGHT(CONCAT('0000',@var2),4)

Ur Voice... Superb !!!

Ty mam...

Or we can just do that DECLARE @var varchar(50), /* whatever length */ @needLength int; /* the final length of sequence */ SELECT CONCAT(REPLICATE('0', @needLength - LEN(@var)), @var) this will compute the needed number of '0' pads and concat it with value NOTE: if LEN(@var) is greater than @needLength REPLICATE will return NULL but CONCAT will ignore that and just return the initial value

Right or left function can create problems with data loss if the input number is beyond 4 digit. Best solution would be to use format function

Thanks

Superb explanation 👌 👏

A more direct solution can be use of FORMAT clause. Select FORMAT(4,'0000')

Regexp videos pls

format('col' , '0000')

Dear Ma'am, Could you please help us with float data type for this scenario? Input : 15.33 159.14 1142:47 output : 0015.33 0159.14 1142:47