You need to remove all the leading whit spaces form Error Code and all the non-printable characters from a SubStatus. All other data must be retained. What should you do on each column?

HOTSPOT

You have a query that retrieves data from a Microsoft Azure SQL database.

You discover that a column named Error Code has several values starting with a space character, and a column named SubStatus contains several non-printable characters.

You need to remove all the leading whit spaces form Error Code and all the non-printable characters from a SubStatus. All other data must be retained. What should you do on each column? To answer, drag the appropriate tasks to the correct columns. Each task may be used once, more than once, or not all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

View Answer

Answer: