Invoiceno

0

Please login or register to vote for this query.

(click on this box to dismiss)

Electrical Engineering

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

DECLARE @InvoiceNo nvarchar(MAX)

SET @InvoiceNo='10,1,2,3,4,5';
declare @n as int;
select @n = len(@InvoiceNo) - len(replace(@InvoiceNo, ',', '')) + 1;

select @n;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results