substring

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  August 25, 2010 at 8:41 am

  #387658

  Hi friends,

  Here is the table I'm doing the select on

  select name, pwd from test

  name(varchar) pwd(varchar)

  -----------------------------------

  Mary At connect

  select CAST(datalength(name) AS VARCHAR) + substring (pwd,3,6) from test;

  4 conne

  But I need the result to be '4 con' (length of test.name + 3rd to 6th character in test.pwd inluding the space)

  Please help...

  Thank you

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  August 25, 2010 at 8:51 am

  #1211689

  Sorry got the answer. I need to use substring(expression,start value,length) Thanks