I have a the following CFQuery which displays the data:

SELETE STATE,PINCODES FROM STATETABLE


Result:
State Pincodes
Texas 100760
Texas 979898
Texas 989867


I want to display the state "Texas to be displayed just once...The records =
now
displayed are unique though.

" Sponsor a needy child...It just costs 65 cents/day less than a chewing gu=
m"

######
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
(@) (@)
----------oOOO-----OOOo---- ...

This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C70D71.2C7E78E0
Content-Type: multipart/alternative; boundary="----=_NextPart_001_0019_01C70D71.2C804DA0"


------=_NextPart_001_0019_01C70D71.2C804DA0