SQiLler

Get Firstname and Lastname from Fullname

Posted on July 12, 2014 by Hiram Romero

It is very common that sometime you will need to split a Fullname column into FirstName and Lastname columns, to do that you just need these functions:

GetFirstName

CREATE FUNCTION [dbo].[ufn_GetFirstName]  
(  
 @FullName varchar(500)  
)  
RETURNS varchar(500)  
AS  
BEGIN  
 -- Declare the return variable here  
 DECLARE @RetName varchar(500)  
  
 SET @FullName = replace( replace( replace( replace( @FullName, '.', '' ), 'Mrs', '' ), 'Ms', '' ), 'Mr', '' )  
  
 SELECT   
  @RetName =   
    CASE WHEN charindex( ' ', ltrim( rtrim( @FullName ) ) ) &gt; 0 THEN left( ltrim( rtrim( @FullName ) ), charindex( ' ', ltrim( rtrim( @FullName  ) ) ) - 1 ) ELSE '' END  
  
 RETURN @RetName  
END

Continue reading “Get Firstname and Lastname from Fullname” »

Reduce SSMS query tabs size

Posted on July 12, 2014 by Hiram Romero

One of the most annoying things of SSMS is that the SQL query tabs are too big, this because it includes Filename + Server + Login User, and I really don’t see the point for that, because you can only visualize 3 or 4 tabs at a time before it starts to collapse the rest, see example:

Fortunately there is away to make the SQL query tabs smaller so you can see more at a time, and here is how: