SQL where only part of string is selected
Posted on 2006-04-05
I would like to create a SQL where I only select the unique first character of the field CompanyName.
So the SQL should be adjusted a little bit.
Select Distinct CompanyName from Companies
Result should be
The second thing I have to do is checking if a caption of a button is within the query-result and if so enable it.
var i : Integer;
for i := 0 to ComponentCount-1 do
if (Components[i] is TdxBarButton) then
TdxBarButton(Components[i]).Enabled := TdxBarButton(Components[i]).Caption >> IN Queryresult(A,G,H);
Thank you for your help.