Discussion:
using a function to extract column data
(too old to reply)
wajid
2013-10-09 09:55:16 UTC
Permalink
Hello
I create a function, then apply bulk insert from csv file now I am trying t
extract a column data after applying a function which convert number to I
Address. how this is possible some one help me out!
Erland Sommarskog
2013-10-09 13:51:38 UTC
Permalink
Post by wajid
I create a function, then apply bulk insert from csv file now I am
trying to extract a column data after applying a function which convert
number to IP Address. how this is possible some one help me out!
Your question is not very clear. But if you have the data in a table,
and the function converts the number to an IP-address, you would do

SELECT dbo.number_to_ip(col) FROM tbl
--
Erland Sommarskog, Stockholm, ***@sommarskog.se
Babu M
2013-10-09 20:11:15 UTC
Permalink
Hello,
I create a function, then apply bulk insert from csv file now I am trying to
extract a column data after applying a function which convert number to IP
Address. how this is possible some one help me out!
Loading...