{"id":8303,"date":"2019-08-04T13:17:27","date_gmt":"2019-08-04T11:17:27","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8303"},"modified":"2021-01-05T23:39:52","modified_gmt":"2021-01-05T22:39:52","slug":"vba-sql-conversion-dune-valeur-numerique-en-une-chaine-de-caracteres","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8303","title":{"rendered":"VBA, SQL : conversion d&#8217;une valeur num\u00e9rique en une cha\u00eene de caract\u00e8res"},"content":{"rendered":"<p style=\"text-align: justify;\">La conversion de donn\u00e9es (ou transtypage) est commune en programmation.<\/p>\n<p style=\"text-align: justify;\">Pour convertir des valeurs num\u00e9riques en donn\u00e9es texte, les langages VBA et SQL utilisent la fonction Cstr.<\/p>\n<p style=\"text-align: justify;\">En VBA :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">Dim Num as Integer\r\nDim Ch as String \r\nNum = 12 \r\nCh = Cstr(Num)<\/pre>\n<p style=\"text-align: justify;\">En SQL, la conversion d&#8217;une valeur num\u00e9rique en une cha\u00eene de caract\u00e8res passe \u00e9galement par la fonction Cstr :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SELECT Cstr(CompteNum) as CompteNumStr\r\nFROM ECRITURES;<\/pre>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a title=\"Programmer en VBA\" href=\"https:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a>, <a href=\"https:\/\/www.auditsi.eu\/?cat=1820\">Ma\u00eetriser le langage de requ\u00eate SQL<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"VBA%2C%20SQL%20%3A%20conversion%20d%27une%20valeur%20num%C3%A9rique%20en%20une%20cha%C3%AEne%20de%20caract%C3%A8res\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>La conversion de donn\u00e9es (ou transtypage) est commune en programmation. Pour convertir des valeurs num\u00e9riques en donn\u00e9es texte, les langages VBA et SQL utilisent la fonction Cstr. En VBA : Dim Num as Integer Dim Ch as String Num = 12 Ch = Cstr(Num) En SQL, la conversion d&#8217;une valeur num\u00e9rique en une cha\u00eene de &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8303\" class=\"more-link\">Continue reading &lsquo;VBA, SQL : conversion d&#8217;une valeur num\u00e9rique en une cha\u00eene de caract\u00e8res&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"VBA%2C%20SQL%20%3A%20conversion%20d%27une%20valeur%20num%C3%A9rique%20en%20une%20cha%C3%AEne%20de%20caract%C3%A8res\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1820,1569,282,215],"tags":[105,2057,2058],"class_list":["post-8303","post","type-post","status-publish","format-standard","hentry","category-requetes-sql","category-programmer-en-vba","category-sql","category-vba","tag-conversion-de-donnees","tag-cstr","tag-transtypage"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8303"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8303\/revisions"}],"predecessor-version":[{"id":9464,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8303\/revisions\/9464"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}