Help with sql code

[dave18]

actually, you said returns the correct value, meaning the query returns only one row? if so then, try:

reader = command.ExecuteReader(CommandBehavior.SingleRow)
If reader.Read Then
return reader.item(0)
endif

This did not help...It still returns 0