SQL Query | Replace special characters | Control Characters | REPLACE function

Показать описание

This video discusses another scenario bases SQL Query interview question.
How to replace special characters from a string?
The REPLACE function can be used to replace special control characters like TAB, Line Feeds and Carriage Returns.

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

Рекомендации по теме

Комментарии

Hi Team,
Do you have the dataset for all the queries in this playlist. If you can arrange, it will be very helpful for me

KeshavRaj-xhhu

Thank you so much my issue got resolved .

PurushottamKumar-kguw

Hello, your videos are very helpful.

Could you please help me with one scenario? I have special characters in my column like à, ñ etc. I want to find only the rows which have special characters in it.

gouravraj

Hi video quality is so poor please upload good quality. Your explanation is very goo.

dravikrish

Thanks for the video.. I want to replace invalid chars but want to exclude carriage return and line feed.. Please suggest

vaishuram

Thanks for this video 🙂
Can we use replace(column_name, CHAR(13)+CHAR(10), ' ')
In short two ASCII characters together..?...
Thanks in advance 😀

sandeepbisht

Mam..please do a video on how to replace special characters in datastage..

sweetysweetyvghb

I am getting a blank space in some datas of a particular column rest I am getting NULL values, when I am replacing the characters of asci value from 0-31 with '' and trimming it, I'm supposed to get null right ? But I'm not getting that, can you suggest a solution for it please ?

sagnikpoddar

could you please provide database links. so it will help us to practice

nagadivyaaraja

I use this replace function, but when I tried to export data in excel by using the query having replace function, it is giving me error. why is it so?

Pranav-fgjr

how do you find an invalid email address that doesn't contain a @ within SQL?

stallgic

How can we replace 2 single quotes to 1 single quotes

shaikhparwez

SQL Query | Replace special characters | Control Characters | REPLACE function

SQL Query | Replace special characters | Control Characters | REPLACE function

Advanced SQL: REPLACE special characters in PHONE and check validity of data using REGEXP

18 how to remove special characters from SQL

30. REPLACE () Function - SQL String Functions

SQL Trick | How to remove all spaces? | TRIM | REPLACE

7| SQL Tutorial| How to find string before, after and in between special character using SQL query

#5: SELECT * REPLACE | SQL Tutorial

How to replace specific string in SQL Server

SQL Server Query Tuning Series- The Hidden Cause of Query Performance Nightmares @jbswiki #sqlserver

How to find and remove special character in a string in SQL SERVER

SQL Trick | Use TRIM to remove different characters | SQL Server #sqltips

SQL tricks | How to update part of a string | UPDATE

SQL Trick | Triple Replace | Reduce Multiple Spaces to Single Space

How to get FIRST CHARACTER of STRING in SQL

SQL Tricks | How to Remove Unwanted Characters from the Beginning of the String? #sqltips

SQL REPLACE() Function

Replacing text in SQL Server: REPLACE, STUFF and TRANSLATE

Find Special Character in a string using Sql

5 Essential SQL Concepts to Ace Your Data Analysis Interview

How to update values in table using replace in SQL server

SQL Tricky Interview Question | Remove Alphabets in SQL | Only Numbers in SQL | Regexp_Replace

SQL | Count(*) vs Count(1) Vs Count(colname) #sqltips

Learn SQL String Search and Replace Functions | Data Analysis in SQL

SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)