mattkovo
asked on
Truncate data in a column?
I have data in a column that looks like this:
dbCatalog=DBTEST&UserID=ad min&StoreI D=12&Group =RG_Name&
When I run a query, I just want to return the UserID (admin) in this scenario.
How can I do this?
dbCatalog=DBTEST&UserID=ad
When I run a query, I just want to return the UserID (admin) in this scenario.
How can I do this?
Actually,
SELECT
SUBSTRING(ColumnName, PATINDEX('%&UserID=%', ColumnName) + LEN('&UserID='), PATINDEX('%&StoreID=%', ColumnName) - PATINDEX('%&UserID=%', ColumnName) - LEN('&UserID='))
FROM
TableName
WHERE
PATINDEX('%&UserID=%', ColumnName) > 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window