Is this possible?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 23 Jun 2003 10:40:54 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703D2B3EE@lnewton.leeds.lfs.co.uk>

Try this :

	SELECT primary_key_fields
	FROM table_name
	WHERE column_name_1 <> UPPER(columns_name_1)
	OR column_name_2 <> UPPER(columns_name_2)
	OR .....

Cheers,
Norman.

--

---

Norman Dunbar (at home on Linux)
Oracle_at_mssqlBountifulSolutions.co.uk

(Delete a Microsoft database name to reply - clue, mssql !)

---

-----Original Message-----

From: mr_a_hernandez_at_yahoo.co.uk (aRo)
[mailto:mr_a_hernandez_at_yahoo.co.uk]
Posted At: Monday, June 23, 2003 10:27 AM Posted To: server
Conversation: Is this possible?
Subject: Is this possible?

In SQL:

Is it possible to check whether a column in a table contains data that is not stored in Upper case?

I need to double check that data in certain columns of table are all stored in upper case.

Advance many thanks Received on Mon Jun 23 2003 - 04:40:54 CDT