pull out username

• saqlainkhan

  Ten Centuries

  Points: 1126

  More actions

  December 16, 2009 at 8:50 am

  #217702

  we are inserting into table system_user for createdby column.

  the data that is being inserted is 'DOMAIN\username'

  we just need the username and not the domain name

  i have used the following code.

  CREATE TABLE X (A VARCHAR(20))

  Declare @final varchar(20),@len int;

  select @final=(system_user);

  set @len = patindex('%\%', @final) +1;

  select @len;

  insert into x values (substring(@final,@len,20))

  select * from X

  is there an easier way to approach this?

  thanks

  Noli Timere

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  December 16, 2009 at 9:44 am

  #1093141

  Here's how I'd do it:

  create table x (A varchar(20))

  insert into x

  select substring(system_user,charindex('\',system_user) + 1,20)

  select * from x

  You can decide if it seems easier.

  Greg