<div>
what in case the phone number is &nbsp;of the format &nbsp;999-99999-999
</div>


what in case the phone number is  of the format  999-99999-999

<div>
It's a varchar (to accept all those parenthesis and dashes), &nbsp;but the table is a bigint, which is why I'm converting it.
</div>


It's a varchar (to accept all those parenthesis and dashes),  but the table is a bigint, which is why I'm converting it.

<div>
I found it's another part of the query that's not working (not shown). Thanks for confirming the above worked.
</div>


I found it's another part of the query that's not working (not shown). Thanks for confirming the above worked.

<div>
<div class="content wysiwyg-content">
My case statement below formats well, however, I'd like to convert the varchar output into a bigint, but I'm not sure where I'm going wrong. I receive the error message: Error converting data type varchar to bigint.<br />
<br />
SET @StorePhone = '(123)456-7891'<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;StorePhone = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CASE SUBSTRING(@StorePhone, 1,1) WHEN '(' <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;THEN 111111111 <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ELSE 222222222 END<br />
<br />
Thanks
</div>
</div>


My case statement below formats well, however, I'd like to convert the varchar output into a bigint, but I'm not sure where I'm going wrong. I receive the error message: Error converting data type varchar to bigint.

SET @StorePhone = '(123)456-7891'

		StorePhone =	CASE SUBSTRING(@StorePhone, 1,1) WHEN '(' 
						THEN 111111111 
						ELSE 222222222 END

Thanks

Formatting CASE statement from VARCHAR to BIGINT

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.