Q:

Sybase SQL Query Clarification

I have a sybase sql query and its returning an integer as the result.
Can anyone explain the logic of this query.
select b.length 
from sysobjects a, syscolumns b
where a.name = 'StuComm' 
and a.id = b.id and b.name = 'StuCD'

A:

I'm kinda unsure what you are asking here, but I'll take a stab at it.
This query is finding the length of the StuCD column in the StuComm table.  It's pulling the information from sysobjects and syscolumns
length is a column in syscolumns of type int, which is why you get an integer result.  The length is the value that the datatype is declared with, so a column with declared as a varchar(255) will have a length of 255.

