I have an issue while getting the file name with out extension from a column in SQL table like this.
The column name is [image]
in dbo.emp
table and the values are:
temp.jpg
test1.jpg
test1.jpeg
sample.jpg
sample1.gif
Now I want to get only temp
, test1
, sample
, sample1
without the extension .jpg
, .jpeg
, etc…
Best Answer
Result:
This doesn't specify what to do if a
.
is not found, however. If you want to deal with that and return th whole string when no.
is found:Results: