Urgent Help Required! [Resolved]

what i share you its a database and i`m really sorry i can`t share database..

My Database like this

ProducttID | ProductName | BrandID
001 | abc | 0
002 | wbc | 0
003 | dbc | 1
004 | fbc | 1
005 | fDc | 0
006 | aDc | 2
007 | aec | 2
008 | acc | 0

when i write this query
select ProductID,BrandID from Catalog.Product
where BrandID='-'

its return 0(zero) records, but its return all those records whose id is 0

Like This

ProducttID | ProductName | BrandID
001 | abc | 0
002 | wbc | 0
005 | fDc | 0
008 | acc | 0

sf_hussain786

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

Normally, Non-Numeric some special characters being converted into 0(ZERO)

See the scenario...

Select CAST('-' as Int), CAST('' as Int), CAST(' ' as Int)

Go

All the column will be return as 0 (ZERO)

I hope "BrandID" column is INT, So when you try to compare the special character '-' (Its converted into 0(ZERO)).

But the following script will work as you expected...

select ProductID,BrandID from Catalog.Product where Cast(BrandID as varchar) = '-'

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

select ProductID,BrandID from Catalog.Product
where BrandID='0'

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

0 (zero) is also a bring id , when i am writing BrandID='-' (dashed) so why are those record return whose Brand ID is 0 , otherwise brand id is 0 is other.

sf_hussain786

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

The Question is this,
this query return 0 record with the brandID="-"
Why this query return those records whose brand id is zero

sf_hussain786

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator

Thank You Pandians , you solve my problem, thank you very much

sf_hussain786

Sf_Hussain786, if this helps please login to Mark As Answer. | Alert Moderator