Welcome to Sign in | Help

Select problem

  •  02-19-2008, 1:27 PM

    Select problem

    selectez un camp nvarchar ce contine codurile unor produse
    ex:
    0001
    0002
    0003
    ERST
    0010
    1090

    cum fac selectul ca sa-mi afiseaze doar cele care sunt intregi

    adica sa-mi afiseze :
    0001
    0002
    0003
    0010
    1090


    am incercat select * from tabela where isnumeric(camp)=1 dar imi afiseaza si cele de tip string
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems