declare @t as table (full_name varchar(30)); Insert into ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @t as table (full_name varchar(30));
Insert into @t(full_name)
Select 'SMITH-EASTMAN,JIM M'  union all
Select 'O''DAY,MARTIN C' union all
Select 'TROUT,MADISON MARIE';

select * from @t;

Enter Parameters

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