حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Convert Float Field to VARCHAR String and then apply Substring in SQL Server

Narendra

Select number,empname,empfathername from emp

where number column is float data type

I need first four dights of number where it consists 10 digits.

num is 1234567890

O/P like to be

1234

Thanks in advance

Mudassar

0 1

Try

DECLARE @S FLOAT
SET @S = 1234567890
SELECT SUBSTRING(LTRIM(STR(@S, 20, 0)), 0, 5)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

3.140.192.22