How can remove the 'tp.','ta.' and 'tta.' from below string from each place where it is coming
str = " tp.FirstName, tp.FamilyName, ta.DOB, tta.TypeOfLocation
WHERE
tp.DateStamp BETWEEN '2012-02-12 15:13:00' AND '2013-02-12 15:13:00'
AND tta.db_name_id =21
AND
tp.FirstName = 'Darlene'";
I need result as below:
FirstName, FamilyName, DOB, TypeOfLocation
WHERE
DateStamp BETWEEN '2012-02-12 15:13:00' AND '2013-02-12 15:13:00'
AND db_name_id =21
AND
FirstName = 'Darlene'";
Note: I have asked same question but this time I am using multiple removing string. Please assist me