×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
When you are declare DDL for an SQL defined table we use a lot of stuff
like
this
NAME <> ' ';
You do this in DDL? Can you give an example DDL statement where you do
this? (Maybe CREATE VIEW?)
Anyway, you have it right. NAME <> ' ' will always and forever expand the
shorter field with blanks until the lengths match, and will then compare.
One blank is and has always been equal to n blanks in SQL unless something's
broken.
create table ab (nam char(150))
Table AB in DLOVELADY1 created but could not be journaled.
insert into ab values(' THOMAS ')
1 rows inserted in AB in DLOVELADY1.
insert into ab values(' ')
1 rows inserted in AB in DLOVELADY1.
select count(*) from ab where nam <> ' '
COUNT ( * )
1
SELECT statement run complete.
select count(*) from ab where nam = ' '
COUNT ( * )
1
SELECT statement run complete.
Can you provide more detail on how this failed for you, please?
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Every generation revolts against its fathers and makes friends with its
grandfathers."
-- Lewis Mumford
midrange.com
