none
Getting 4 characters from a float type

    Вопрос

  • Hello;

    I've a table that has a column barcode float type.

    When i want to get 4 charachters from 4th index, it returns me incuding exponent 'e'

    For example;

    8699502093393

    is should return me '9502' but,

    SUBSTRING(CAST(barcode as nvarchar(max)),4,4) 

    SUBSTRING(CONVERT(NVARCHAR(MAX),barcode),4,4) 

    both return me 995e

    How can i solve this problem?

    *I must use barcode in float type

    8 июня 2012 г. 21:19

Ответы

Все ответы