chracter to hexdecimal çevirimi

cast() SQL server ve hatta C'dfe oldugu gibi 'casting' yapiyor:) Bir tipi baska bir tipe ceviriyor. VFP de:

str(), val(), ctot(), dtoc() vs vs ozel cevrim fonksiyonlari var. Oysa boyle her cevrim icin bir fonksiyon yerine cast() hepsini yapan tek fonksiyon gibi.

cast(1 as varchar(10))  = ltrim(str(1))
cast(1 as int) = int(val("1"))
cast(1 as logical) = .t.
cast(datetime() as date) = date()
cast("^2008/3/30" as date) =  ctod("^2008/3/30")
...
gibi. Onemli kullanim yeri SQL.

select cast("" as m) as myMemo, ;

 cast( evl(tarih, null) as date) as tarih, ;

 cast( 0 as int) ...

Cast olmasa ilk ikisi imkansiz gibi - ayni cok zor (linked serverla data almak istedigini dusun).

Bunlar gercek calisan koddan:

where cast(appt_off as int) = 1

Select a.rec_id, a.appdate as _appdate,

  cast(a.appDate as Datetime) + (cast(a.appTime as Datetime)-cast('0:0' as Datetime)) As [Start],

  cast(a.appDate as Datetime) + (cast(a.endTime as Datetime)-cast('0:0' as Datetime)) As [End],

cast olmasaydi VFP ve SQL server icin ayri ayri yazmam gerekecekti.