CREATE A VIEW 1

[cristi22]

Hello all!

Really appreciate your help!

1) How do check if the length of the ALPHA is 1
2) How do I create a view based on the following conditions?

select count(member_key) from member where
length(ALPHA) = 1 ????? 
and  (ADDRESS_2 is null OR ADDRESS_2 = '' ) and
(ADDRESS_3 is null   OR ADDRESS_3 = '' ) and
(ADDRESS_1 is null  or  ADDRESS_1 = '' ) and
(COUNTRY_CODE is null  OR COUNTRY_CODE = '' ) and
(ZIP_CODE is null  OR ZIP_CODE = '' )

 

[ddiamond]

1) length(ALPHA) = 1 should work. What problem are you having with it?

2)

create view myview as
  select count(member_key) from member where
  length(ALPHA) = 1  
  and  (ADDRESS_2 is null OR ADDRESS_2 = '' ) and
  (ADDRESS_3 is null   OR ADDRESS_3 = '' ) and
  (ADDRESS_1 is null  or  ADDRESS_1 = '' ) and
  (COUNTRY_CODE is null  OR COUNTRY_CODE = '' ) and
  (ZIP_CODE is null  OR ZIP_CODE = '' )

 

[cristi22]

it worked:

create view  _view as 
select *  from member where
length(ALPHA) = 1 and
(ADDRESS_2 is null OR ADDRESS_2 = '' ) and
(ADDRESS_3 is null   OR ADDRESS_3 = '' ) and
(ADDRESS_1 is null  or  ADDRESS_1 = '' ) and
(COUNTRY_CODE is null  OR COUNTRY_CODE = '' ) and
(ZIP_CODE is null  OR ZIP_CODE = '' )