How would that code be in SQL Server?

microsoft.public.sqlserver.programming

14 May 2005 9:50 PM

Frank Dulk

How would that code be in SQL Server?

UPDATE BASE SET BASE.cpf = "0"+[cpf]
WHERE ((Len([cpf])="10"));

14 May 2005 9:53 PM

Mike Epprecht (SQL MVP)

UPDATE
    BASE
SET
    BASE.cpf = '0'+cpf
WHERE
    Len(BASE.cpf)=10

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quote

"Frank Dulk" <fd***@bol.com.br> wrote in message
news:uaeTN6MWFHA.2128@TK2MSFTNGP15.phx.gbl...
> How would that code be in SQL Server?
>
> UPDATE BASE SET BASE.cpf = "0"+[cpf]
> WHERE ((Len([cpf])="10"));
>
>