Sorry. The field type of NTEXT. I want to just query the data and store
it in another column as an int.

You were close, though. This is an MSSQL application, but the original
platform was Access.

How do I extract the INT value from the NTEXT field?

-----Original Message-----
From: Swasey Steve D CTR 554 ELSG/FNF
[mailto:mssqldba-ezmlmshield-x90644446.[Email address protected]
Sent: Tuesday, January 30, 2007 3:41 PM
To: LazyDBA Discussion
Subject: RE: Memo to INT

Mike:

I assume you're talking about MS Access?

You can just change the data type of the field from Memo to Number and
all the values should automatically convert.

Steve


-----Original Message-----
From: Hillwig Mike
[mailto:mssqldba-ezmlmshield-x39550996.[Email address protected]
Sent: Tuesday, January 30, 2007 3:22 PM
To: LazyDBA Discussion
Subject: Memo to INT

Our project management system stores all of the user preferences in a
memo field. Is there a way to scrub the field down to an integer field?
I know the contents of the column are actually an integer. I need to use
this for some comparisons, and it's driving me crazy.





Mike Hillwig, Database Systems Specialist
Shawmut Design and Construction
[Email address protected] <BLOCKED::mailto:[Email address protected]
P: 617-622-7792
F: 617-622-8792
C: 617-304-7582





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page