ok thank you I use it but in wrong way
isnull not is null ok thank you "Luiz Papa" <papa at matrix dot inf dot br> escribi� en el mensaje news:[EMAIL PROTECTED] > try: > select * from VEHICULOS where IDEQUIPO is null > > Luiz Papa > > "Marcus" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] > > hi all > > I need i help with this query (SQLMANAGER) > > > > I have a class VEHICULOS with the property > > > > Property IDEQUIPO As %Numeric(SCALE = "", XSDTYPE = ""); > > > > and I have values > > example > > > > ID IDEQUIPO IDCLIENTE > > 1 100 1 > > 2 101 1 > > 3 1 > > 4 103 2 > > 5 102 3 > > 6 4 > > 7 110 4 > > > > IF I make this query is ok > > select * from VEHICULOS where IDEQUIPO <>"" > > > > ID IDEQUIPO > > ID IDEQUIPO IDCLIENTE > > 1 100 1 > > 2 101 1 > > 4 103 2 > > 5 102 3 > > 7 110 4 > > or it's ok > > select * from VEHICULOS where IDEQUIPO =101 > > ID IDEQUIPO IDCLIENTE > > 2 101 1 > > but if want to see empty value of IDEQUIPO I can't > > > > select * from VEHICULOS where IDEQUIPO ="" > > select * from VEHICULOS where IDEQUIPO =null > > these queries not work > > > > > > how can I see this query > > > > I want to see it > > > > ID IDEQUIPO IDCLIENTE > > 3 1 > > 6 4 > > > > > > thankyou for your help > > > > Marcus > > > > > >
