Welcome to Sign in | Help

Re: Convert() !

  •  09-21-2007, 1:04 PM

    Re: Convert() !

    SELECT MIN(CAST(REPLACE(coloana, ',', '.') AS float)) FROM tabel

    functioneaza...

    Folosesc CAST pentru ca minimul sa fie "ales" dintre valori numerice. Altfel poti sa alegi un "minim" si dintre valori varchar, dar ele vor fi sortate alfabetic...

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems