Can you pleaee break up your long lines?

Question.. What about TOP 1 or TOP 10 or something like that?

For example:
Code:

SELECT TOP 1 cid FROM computers WHERE Name='$HostName' AND MACAddress='$MAC'


HTH,

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's