October 10, 2011 at 11:20 pm
I m having data like this
accountno account details
1 details-asset
2 details-demand
3 liabilty
but when i deploy a report i want to show only
accountno account details
1 asset
2 demand
3 liabillity
i want to remove the word "datails-" how can i do this
October 10, 2011 at 11:44 pm
Approach 1: Use SSIS transformation on your Db column and use "-" as a delimiter to create a new column and then use that package as a Data Source
Approach 2: Use SQL for the same activity (hints: you might consider using PATINDEX AND/OR SUBSTRING)
Raunak J
October 11, 2011 at 8:39 am
In your query make the Account Details column like this
CASE WHEN [Account Details] LIKE 'details-%' THEN RIGHT([Account Details],LEN([Account Details])-8) ELSE [Account Details] END AS [Account Details]
October 11, 2011 at 11:44 pm
ya i got that ans..thanks for u rreply
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply