Sample Header Ad - 728x90

Select INTs from start of string separated by a character (pipe). Update other columns using these INTs

-4 votes
1 answer
251 views
enter image description here In the above screen shot, the *Description* column has many special characters. We want before | number update in T1 column and | after number in T2 column. Please suggest the proper syntax. If there are no before and after | numbers, like the second row | SE +17.5D CYL1.25 update columns T1 and T2 null.
Asked by karthik sanapala (37 rep)
Jan 29, 2022, 10:01 AM
Last activity: Feb 2, 2022, 05:35 PM