How can I get these values with a match field that has different file extensions.

• the.roof

  SSC-Addicted

  Points: 430

  More actions

  March 14, 2013 at 12:57 am

  #275188

  Hello and thank you for the help.

  I am trying to write a select statement where I can view 3 columns by a filename with a join statement. Unfortunately the value in both filenames match but their file extensions do not. Here is an example:

  6024500036687.pst.txt = 6024500036687.pst.msg.htm

  As you see the first piece of the filename match but the file extensions do not.

  Any suggestion will help. I am fairly green and would greatly appreciate the help.

• zzalina0

  SSCommitted

  Points: 1524

  More actions

  March 14, 2013 at 2:17 am

  #1596866

  Hi)

  If the filename is the part of string before the first ".", you can use:

  declare @name nvarchar(15)

  set @name='filename.extention'

  select substring(@name, 0, charindex('.',@name))