Hi all, Is there a way to format a string in SQL ?

Example: SELECT Id, Name, Phone FROM Contacts
Returns: 1, Tony, 0411234234

I would like to return: 1, Tony, (0411) 234-234

Aaron,


SELECT
  Id, Name, '(' + SUBSTRING(Phone, 1, 4) + ') ' + SUBSTRING(Phone, 5, 3) + '-' + SUBSTRING(Nome, 8, 3)
FROM
  Contacts


The other option would be to write a user defined function, but if you use Client/Server that means recompiling the server.

--
Fernando Dias
[Team Elevate]

Aaron,

Correction: It should be "Phone" instead of "Nome".

--
Fernando Dias
[Team Elevate]

Thank You