text: --create range partition table with string data type and one partition having  maxvalue,then insert data to this table,then update the separator field value,the data is in the boundary of the separator value
  
  create table range_test(id int ,
  				test_char char(50),
  				test_varchar varchar(2000),
  				test_bit bit(16),
  				test_varbit bit varying(20),
  				test_nchar nchar(50),
  				test_nvarchar nchar varying(2000),
  				test_string string,
  				test_datetime timestamp, primary key(id,test_string))
  	PARTITION BY RANGE (test_string) (
  	    PARTITION p0 VALUES LESS THAN MAXVALUE
  	);
  	insert into range_test values(1,'aaa','aaa',B'1',B'1011',N'aaa',N'aaa','aaaaaaaaaa','2007-01-01 09:00:00');
  	insert into range_test values(2,'bbb','bbb',B'10',B'1100',N'bbb',N'bbb','bbbbbbbbbb','2007-01-01 09:00:00');
  	insert into range_test values(3,'ccc','ccc',B'11',B'1101',N'ccc',N'ccc','cccccccccc','2007-01-01 09:00:00');
  update range_test set test_string   = 'dddddddddd' where test_string   = 'cccccccccc'; 
  select * from range_test  order by 1;
  
  
  drop table range_test;
  