declare @randnum nvarchar(50) declare @OrderNo NVARCHAR(50)set @randnum=CONVERT(nvarchar,(select cast( floor(rand()*1000) as int)),11)SET @OrderNo='1111110'+ @randnumSELECT @randnumselect @OrderNo