Sql query having problem

[kirubagari]

my sequel as below

SELECT lot.lotid || '.' || comp.POSITION inhousescribe,					
 comp.componentid vendorscribe				  	
FROM hdbxuser.fwhdblot@hdbsil lot,					
 hdbxuser.fwhdbwipcomponent@hdbsil comp					
				   WHERE lot.lot_sk = comp.originallot_sk	
				     AND comp.lot_sk = '577137'	
				     AND '1122571595' BETWEEN startsequence AND stopsequence 	
				     AND comp.status <> 'Scrapped'
             AND comp.position <> null
					 ORDER BY comp.componentid;

Im having issue where data is not extracted correctly..

How i should use the NULL in oracle?

[Rabbit]

You can't use <> for Nulls, you have to use the keywords IS NOT NULL.