Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 SQL HELP

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-03-16 : 16:32:53
i need a plsql query that Check if any of the phone numbers in table A have not been entered in the (###)###-#### format. tHEN Show EVeryone in the incorrect format

also

I would like to Write an SQL statement that uses the CAST function that converts a number datatype to a varchar datatype.


a SQL statement that converts a date datatype to a char datatype.



FINALLY A SQL statement that convert a number value to a character

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-03-16 : 18:59:40
SQLTeam.com is in Microsoft SQL Server. For Oracle questions try dbforums.com.




KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -