Write an SQL to find all records having all upper case alphanumeric characters in a field ?

Javasearch.buggybread.com

Search Interview Questions

More than 3000 questions in repository.

There are more than 900 unanswered questions.
Click here and help us by providing the answer.

Have a video suggestion.
Click Correct / Improve and please let us know.

Submit Question

Interview Questions and Answers

Q1. Write an SQL to find all records having all upper case alphanumeric characters in a field ?

Ans. Select * from Table where field = upper(field)

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database}

Related Questions

What are Inner , Outer , Left and Right Joins in SQL ?

What is JDBC? Describe the steps needed to execute a SQL query using JDBC.

What is a self Join and give an example of a self Join ?

or

What is self Join and What is it's purpose ?

Do you like Native SQL Apis like JDBC or JPA / Hibernate ?

Is there any schema in mongo DB ?

Difference between Inner and Outer Join ?

What is a Cursor ?

What are temp tables ?

Does SQL allow null values ? Can we use it within Where clause ?