Question: I ' m trying to get only the first date of the End Date changed from even if it's null. I did this, but I
Im trying to get only the first date of the "End Date changed from" even if it's null. I did this, but Im still getting additional numbers in some of my results. What am I doing wrong?
DROP TABLE #Store
CREATE TABLE #Store
Description varchar
;
INSERT INTO #Store Description
VALUES Store Pricing Plan # modified. End Date changed from NULL to
Store Pricing Plan # modified. End Date changed from NULL to
Store Pricing Plan # modified. Start Date changed from to End Date changed from to Store Pricing Plan changed from NULL to Store Plan'
SELECT
#Store.Description
SUBSTRING#Store.Description NULLIFCHARINDEXEnd Date changed from #Store.Description LENEnd Date changed from 'End Date'
FROM #Store
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
