Not getting desire output from function using T-SQL

Question

I have created small function using T-SQL which takes one input parameter as phone number and returns area code from it. Function compiles successfully but getting only first digit of the phone number instead of three digits.

Refer below code:-

create or alter function getareacode (@phoneno as nvarchar)
returns nvarchar(10)
with schemabinding 
as
begin
  declare @areacode as nvarchar(10);
  select top(1) @areacode = value from string_split(@phoneno,'-');
  return @areacode;
end;

select dbo.getareacode( N'123-456-789');

LEFT(@phoneno, PATINDEX('%-%', @phoneno)-1) can also get you everything before the first - — Nenad Zivkovic
– Nenad Zivkovic, Commented Aug 15, 2017 at 23:09

John Cappelletti · Accepted Answer · 2017-08-15 23:02:48Z

4

(@phoneno as nvarchar) will generate the 1st character only

try

(@phoneno as nvarchar(50))

However, the split may not be necessary

Try the following. It may be more performant

Declare @S nvarchar(50) = '123-456-789'

Select left(replace(replace(replace(@S,'-',''),'(',''),')',''),3)

answered Aug 15, 2017 at 23:02

John Cappelletti

82.3k7 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Not getting desire output from function using T-SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related