Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RWord CAST

Status
Not open for further replies.
ebarratt

ebarratt

Programmer
Apr 10, 2002
53
US
Can anyone tell me what this select statment is doing I do not understand the cast statement nor can i find it in my SQL Server books....

Select TABLE.Field, TABLE.Field, ISNULL(CAST(Field AS varchar(25)) + ' ' + TABLE.Field, '')


Anyone know what they are trying to do with the ISNULL(CAST( operation? any help would be great thanks all Errol Barratt
856-697-1593
New Jersey
 
Status
Not open for further replies.

Similar threads

keak
  • Locked
  • Question
using cast sql statement in a adodb.connection
Replies
3
Views
125
Sheco
Sheco
amorous
  • Locked
  • Question
Help on CAST function
Replies
14
Views
23
onpnt
onpnt
PhatH
  • Locked
  • Question
Casting and Comparing
Replies
4
Views
35
onpnt
onpnt

Part and Inventory Search

Sponsor

Back
Top