Add number or text to the middle of that value

[LAHIRU92]

I want to add "0" to third charactor position,if the legth of the text less than 6 charactors, otherwise need to dhow the original value,I wrote the sql code as below,but this did not give the current value if the length of the text more than 6 

if Text.Length[AR_ID]<6 then Text.Insert(Text.From[AR_ID],2,"0") else Text.From[AR_ID]

[Greg_Deckler]

@LAHIRU92 Well LEN is the length function. I don't believe there is an equivalent for Insert, you would likely have to use STRING_SPLIT and then stich things back together. String Functions (Transact-SQL) - SQL Server | Microsoft Learn

Here is the IF statement definition: IF...ELSE (Transact-SQL) - SQL Server | Microsoft Learn

[Greg_Deckler]

@LAHIRU92 Pretty sure this is Power Query M code and not SQL and pretty sure you want this:

if Text.Length([AR_ID]) < 6 then Text.Insert(Text.From([AR_ID]),2,"0") else [AR_ID]

[LAHIRU92]

Thanks @Greg_Deckler , what is the SQL Code for above scenario